Post reply

Replication

  • May 23, 2019 at 7:12 pm

    #3646641

    Stop transactional replication steps,

    Step 1

    Stop Log Reader Agent

    Local publication folder and then right click a publication

    Click View Snapshot Agent Status or View Log Reader Agent Status

    Click stop

    Step 2

    Expand SQL Server Agent folder and then expland Jobs folder

    Click Stop REPL-Distribution Job

    Let me know if I am missing any? How long it can be paused?

     

  • May 23, 2019 at 8:05 pm

    #3646653

    Usually only Log Reader and Distribution agents running continuously. So, you don't need to stop Snapshot.

    As to how long it can be paused, it depends on you environment. If replicated tables are frequently updated the longer you pause the longer it will take to catch up when you turn it back on.

    • This reply was modified 5 years, 7 months ago by  rVadim.

    --Vadim R.

  • May 23, 2019 at 8:45 pm

    #3646671

    More important that if you stop log reader agent then log on publisher database will start to grow as the transaction must wait in log to be distributed to distributor, if you stop distribution agent then distribution db may start to grow and by default after 3 days subscriber will be out of sync and you will need to resynchronize it by generating a new snapshot.

    So keep this in mind and watch out the free space on disks, if you want suspend it for long time maybe it will be better removing subscription?

  • May 24, 2019 at 5:12 pm

    #3647063

    Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply