How do I suspend replication?

If I need to do maintenance on my distributors or subscripers, how do I suspect replication until I am finished?

more ▼

asked Dec 26, 2009 at 01:17 PM in Default

avatar image

Steve Jones - Editor ♦♦
5.1k 79 93 87

If I had enough points to edit, I'd fix your "suspect" word.

Dec 26, 2009 at 09:52 PM Rob Farley
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You can either stop the Agent Serivce (if there are no other essensial dependancies) or disable the distribution agent and the log reader jobs.

Stop any log backups if you are truncating the logs after it is backed up. Keep and eye on your log size if you do this!

Merry xmas too and hope you have a top New Year... Keep up the good work!

more ▼

answered Dec 26, 2009 at 03:43 PM

avatar image

10.5k 27 37 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 26, 2009 at 01:17 PM

Seen: 2309 times

Last Updated: Dec 26, 2009 at 01:17 PM

Copyright 2016 Redgate Software. Privacy Policy