title: Pause SQL server replication temporarily
body: <p>We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber.</p>
  
  <p>We have an activity to change the location of the replicated DB (subscriber) using de-attach  and attach method. During this activity, I will need to stop the SQL server and hence all replicated transactions will fail.</p>
  
  <p>What's the proper way to pause the replication during this activity, so when I attach the DB again and start the SQL service, replication will resume normally.</p>
  
  <p>Thanks</p>