December 25, 2009 at 12:19 pm
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 ?
Thanks
December 25, 2009 at 12:27 pm
With the understanding that it will suspend all jobs, you could simply turn of the SQL Server Agent until you're done.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 25, 2009 at 3:03 pm
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.
---------------------------------------------------------------------
December 25, 2009 at 5:12 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply