Wednesday, March 21, 2012

Pause Transactional Replication

Is there an easy and quick way to temporarily pause replication on a specific
publication/subscription and then start it back up again?
Thanks,
Mark
You could stop the distribution agent and then disable it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

No comments:

Post a Comment