We have transactional replication using 3 SQL servers, 1st as a publisher, 2nd as a distributor and 3rd as a subscriber.
We have activities to change the location of a replicated database (subscriber) using the de-attach and attach method. During this operation, I need to stop the SQL server, and therefore, all replicated transactions will fail.
What is the right way to pause replication during this action, so when I re-attach the database and start the SQL service, replication will resume normally.
thank
source
share