November 12, 2004 at 2:39 am
I hope you guys can shed some light on an issue I am having with one of our SQL boxes. The server itself is running SQL 200 SP3. The problem is that it is the publisher for a merge publication and the msmerge_contents table is verging on 3 million rows. I have tracked the problem down to the -MetadataRetentionCleanup option, which is not listed in the merge agent profile where it is supposed to be. I have tried adding it as switch for when the Merge Replication Agent starts but it did not cleardown at all.
November 13, 2004 at 8:20 am
you should check your retention period for the publication. It is usually 14 days if you chose the default value. sp_mergeretentioncleanup It will only clean up rows that have expired beyond the retention period.
You can spy on sp_mergemetadataretentioncleanup
to see what is doing
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply