December 31, 2004 at 6:32 am
Please can someone tell me the best way to stop replication on both publisher and subscriber servers before one or both of them is rebooted? We have had timeout issues and currently have to manually stop and start the replication agents for it to start working again. Any suggestions greatly appreciated.
January 3, 2005 at 8:00 am
This was removed by the editor as SPAM
January 3, 2005 at 10:30 am
To stop replication before you reboot server - stop SQL Server Agent on Distributor.
What kind of timeouts do you have? Can you give more information? Do your replication agents have option -Continuous ?
January 6, 2005 at 5:24 pm
yes, the distributor is where the replication agent resides. stopping SQL Server Agent will stop the replication threads. You can also stop them individually by going into the replication monitor folder and manually stop them one-by-one. Sounds like you might have a deeper problem if you can't even seem to get through a reboot without replication crapping out on you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply