We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!


move merge replication without snapshot

ICM_IT asked
Last Modified: 2008-03-06
Hi Experts,

We have a big challange here.
We are running SQL2000 here with a merge replication to SQL2000 Servers.
Let me describe at follows.

D_exist = Distributor SQL 2000
D_new = Distributor SQL 2005
S1-5 = Subscriber

The database is around 10GB. The bandwith between the D*+S is at max about 512kB, so not the best speed.

Well now the D_exist is on old Hardware situated, and we have to move the server to other hardware. We have installed a new server as D_new. That Server is also up and running. Well, now we have to migrate that particular database from D_exist to D_new. How can we do that?

Is it possible to:
- stop the replication
- delete publication and delete all subscriptions
- move the DB to D_new
- create a new publication
- tell the server that all the date on the subscribers are available (and if yes, how)
- start the replication

are there other possibilities to move such a replication without copy the snapshot.

thank you
Watch Question

Kevin HillSr. SQL Server DBA

Nope.  Replication is dependent on the server name(s), so if you can do it at all the new physical server must end up with the same name as the old one when replication was established.  Stop all the agents, move all the databases to the new server, rename it, test, restart the agents (high-level there...not exact steps).  If it works that is how it will work.

Test first on different boxes.


thank you

is it possible to start a replication without make a snapshot. I mean the data is still at the locations, and I want to start the replication with existing data.
Sr. SQL Server DBA
Unlock this solution and get a sample of our free trial.
(No credit card required)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.