Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 meta data cleanup

Author  Topic 

ozgunnew
Starting Member

13 Posts

Posted - 2006-09-28 : 17:27:33
Hi;
I am so confused.
I can not understand retention based clean up.
Is meta data cleaned after this period?
Which meta data is cleaned? Only applied rows are deleted or all rows are deleted after retention period? Is MSmerge_contents evaluted by auto clean up row by row basis to decide which row to delete and which row to not?
Why sql server do not delete finished metadata when merge agent runs and it waits for retention time?
Thank you for your help...
   

- Advertisement -