Post reply

How to suspend replication ?

  • December 25, 2009 at 12:19 pm

    #218981

    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

    #1096488

    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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 25, 2009 at 3:03 pm

    #1096491

    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

    #1096493

    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