troubleshooting Question

SQL 2008 move merge replication - remote distributor

Avatar of Russell_Harper
Russell_HarperFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft Development
3 Comments1 Solution728 ViewsLast Modified:
I have a client who's SQL Server is being used as a OLTP database server and a distributor to 42 subscribers using merge replication.  Each of the 42 subscribers are running SQL 2008 R2 Express so can only subscribe to a push publication.

The client is looking to purchase a new server and migrate the OLTP database to it and the plan is to use the existing server as a remote distributor (all the data that is replicated resides in the OLTP database).  The idea here is to reduce the amount of work the OLTP server is doing.  Is it possible to migrate replication without having to set it up from scratch again?  The volume of data that needs to be replicated means there isn't a long enough window to reapply new snapshots to the subscribers should this be the case.

Just to recap:

In the currency scenario they have SERVER1.  This is the OLTP server and distributor.
In the new scenario they have a new server SERVER2.  This will be the OLTP server and SERVER1 will be the remote distributor for replication.

Any advice would be appreciated.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros