Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to suspend replication ? Expand / Collapse
Posted Friday, December 25, 2009 12:19 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 27, 2015 2:19 PM
Points: 569, Visits: 2,109
I need to suspend transactional replication between servers (distributor is running on publisher server). I need to temporarily stop replication to do some maintenance and then resume it. What jobs(s) should I disable ? Or maybe there is some sp_... to do this ?
Post #839164
Posted Friday, December 25, 2009 12:27 PM



Group: General Forum Members
Last Login: Yesterday @ 8:13 PM
Points: 38,979, Visits: 36,068
With the understanding that it will suspend all jobs, you could simply turn of the SQL Server Agent until you're done.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014

Helpful Links:
How to post code problems
How to post performance problems
Post #839166
Posted Friday, December 25, 2009 3:03 PM


Group: General Forum Members
Last Login: Wednesday, November 25, 2015 6:17 AM
Points: 6,008, Visits: 13,319
There's not that many, the log reader agent and the distribution agent should be disabled. Snapshot as well if you have that enabled. Keep an eye on log growth whilst the log reader is disabled.


Post #839170
Posted Friday, December 25, 2009 5:12 PM



Group: Administrators
Last Login: Yesterday @ 8:47 PM
Points: 32,698, Visits: 17,003
George is correct, watch the log. The log transactions should not clear until they've been copied out of the distributor, even with log backups. So your log may grow if the system is in use

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #839173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse