暂时暂停SQL Server复制 [英] Pause SQL server replication temporarily
问题描述
我们有一个使用3个SQL Server的事务复制设置,第一个作为发布者,第二个作为分发者,第三个作为订阅者。
We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber.
我们有一个活动来更改位置使用取消附加和附加方法复制复制的DB(订户)。在此活动中,我将需要停止SQL Server,因此所有复制的事务都将失败。
We have an activity to change the location of the replicated DB (subscriber) using de-attach and attach method. During this activity, I will need to stop the SQL server and hence all replicated transactions will fail.
在此活动中暂停复制的正确方法是什么?再次附加数据库并启动SQL服务,复制将正常恢复。
What's the proper way to pause the replication during this activity, so when I attach the DB again and start the SQL service, replication will resume normally.
谢谢
推荐答案
请参阅以下链接以获取有关如何完成此操作的详细信息:
Please see the following link for details of how to accomplish this:
以上文章似乎没有提供有关停止分发代理程序的信息,这可以通过使用下面的链接中详细介绍的存储的proc来实现:
The above article doesn't appear to give information on stopping the distribution agent, this can be achieved by using the stored procs detailed in the link below:
这篇关于暂时暂停SQL Server复制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!