By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

MSMerge_tombstone cleanup

P: n/a
Hi to everybody.

Situation:
1) merge replica
2) Two publications with many subscribers (about 60 for each publication).
3) One subscriber has a monodirectional agent (data only from publisher to
subscriber)
4) In this subscriber I delete data older than one month
5) MSMerge_Tombstone of this subscriber is very huge (more than 10 million
of records)

How can I clean these data? Can I use 'DELETE FROM MSmerge_tombstone' in the
subscriber?

Thanks for your answers and help.

Marco

PS: I cannot use sp_mergecleanupmetadata because I cannot neither
reinitialize all subscriptions neither synchronize them before/after this
procedure
Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.