move merge replication without snapshot

Posted on 2007-10-01
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
Question by:ICM_IT
    LVL 21

    Expert Comment

    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.
    LVL 1

    Author Comment

    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.
    LVL 21

    Accepted Solution

    Yes, with some types you have the option to tell the wizard that the data is already there.  MS has an article ( on initializing replication using a backup/restore method for transactional and merge.  Its been awhile, but I talked three or four customers through it last year

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now