Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Pause SQL server replication temporarily

We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber.

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.

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.

Thanks

like image 468
PyQL Avatar asked Feb 20 '13 14:02

PyQL


1 Answers

Please see the following link for details of how to accomplish this:

Start and Stop a Replication Agent

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:

Start/Stop SQL Server Replication Agent using TSQL

like image 82
steoleary Avatar answered Sep 19 '22 16:09

steoleary