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


Group: General Forum Members
Last Login: Today @ 1:18 PM
Points: 492, Visits: 1,672
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: Today @ 3:04 PM
Points: 36,654, Visits: 33,409
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

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: Today @ 5:42 AM
Points: 5,916, Visits: 13,122
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: Today @ 11:42 AM
Points: 31,667, Visits: 16,128
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