sql server replication: Moving a replication to a new server -- sql server replication

Moving a replication to a new server

jaylou
5/30/2006 6:47:02 AM

sql server replication:

Hi all,
I am in the process of migrating to a new server for my production. I have
a few tables that I replicate to another server from this server. Should I
restore my Distribution DB over as well as all of my other DB's? I will be
renaming this new server to the old servers name and changing the IP as well.

Do I need to recreate the replication on my new server from scratch as well
as restoring the distribution? Or should I just recreate the replication,
which will create the dist DB.

Thanks,
Joe

Re: Moving a replication to a new server

jaylou
5/30/2006 7:45:02 AM

Thank you. I wasn't sure which way to go.

Thanks again.
Joe

[quoted text, click to view]

Re: Moving a replication to a new server

Paul Ibison
5/30/2006 3:18:23 PM

Joe,
if you're restoring master, msdb, distribution and publishing databases,
this should be possible, provided they are in sync. In practice, I'd almost
certainly script out the publication and subscription, restore the
publisher's database then run the scripts and initialize.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: Moving a replication to a new server

Paul Ibison
5/30/2006 4:04:23 PM

Also, it might not be relevant to you, but don't forget about nosync
initializations
(http://www.replicationanswers.com/NoSyncInitializations.asp).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.