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
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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment