Hi,

During Datacenter migration, following steps are planned to stop a configured Peer to Peer replication setup between two servers.

1. Stop all the inflow of data (Stopping the application and Services)

2. Check for any pending transaction in Publisher/Subscriber

3. When pending transactions is zero, stop the distribution and Log reader agents on both Peer1 and Peer 2 (4 agents to be stopped totally)

Are these steps correct or am I missing something? Kindly provide your inputs.

I could test the above successfully for transactional replication, but due to testing constraints, could not test it for a Peer to Peer replication setup.

• Edited by Jebah 20 hours 51 minutes ago

Hi Jebah,

In addition to your steps, please back up the system databases and user databases. Also I recommend you script out the whole replication topology before implement datacenter replication.

For more details about scripting out replication, please review the following blog.
http://blogs.msdn.com/b/repltalk/archive/2011/09/25/using-power-shell-to-script-out-replication.aspx


Thanks,
Lydia Zhang

Thank you Lydia.. we do backup databases before migration.

As a fallback plan, we have scripts that drop the replication setup and create it again.

Thanks,

Jebah

• Edited by Jebah 5 minutes ago