move merge replication without snapshot

Posted on 2007-10-01
Medium Priority
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
  • 2
LVL 21

Expert Comment

ID: 20013970
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.

Author Comment

ID: 20014128
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

Kevin3NF earned 2000 total points
ID: 20014207
Yes, with some types you have the option to tell the wizard that the data is already there.  MS has an article (http://support.microsoft.com/kb/320499/en-us) 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

840 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