Monday, November 2, 2009

Pausing SQL Server transactional replication without losing queue contents

To Pause:
  1. Open SSMS and connect to the distributor
  2. Disable and Stop the "Distribution clean up: distribution" job
  3. Expand SQL Server Agent, right-click on Jobs, select View Job Categories and choose REPL-Distribution
  4. Disable and Stop all listed jobs
To Continue:
  • Enable and Start all the jobs that were stopped
I have seen countless forum discussions for this topic but no succinct list of steps.

No comments: