Strategy for restoring merge replication on SQL Server 2008
Posted on 2013-01-15
We have merge replication setup with a publisher, a distributor and 28 subscribers. Now we need to migrate the publisher and distributor servers to another server running on VMWare environment over the private Cloud.
There are a few challenges for us for this migration exercise -
1) Our current data center has very limited access to the cloud environment which only allows us to do remote desktop or web portal.
2) Limited bandwidth between our Data Center and Cloud which is only 40 MB.
3) After restore the publisher and distributor, we couldn't afford to reinitialized all the 28 subscribers due to limited bandwidth of our subscriber connection which is only 2 MB.
4) Our down time is only 8 hours and we have to complete everything within this window.
I have experience in migrating other database servers to the cloud but those database servers did not have any replications. This is my first time to migrate the database servers with merge replication to another server.
Kindly advise me what should be the steps to restore the publisher and distributor without the need of reinitializing the replications.
I have both push and pull merge replications and subscribers are using the Microsoft Synchronization Manager to sync the pull replication.
Thank you in advance.