all groups > sql server replication > december 2004 >
You're in the

sql server replication

group:

MSMerge_tombstone cleanup


MSMerge_tombstone cleanup Marco
12/27/2004 6:03:55 PM
sql server replication:
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

Re: MSMerge_tombstone cleanup Paul Ibison
12/30/2004 8:42:11 PM
Marco,
sounds like sp_mergecleanupmetadata should fix this. Have a look in BOL.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button