Moving a replication to a new server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaylou - 30 May 2006 14:47 GMT

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

Reply to this Message

Paul Ibison - 30 May 2006 15:18 GMT

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

Reply to this Message

jaylou - 30 May 2006 15:45 GMT

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

Thanks again.
Joe

> Joe,
> if you're restoring master, msdb, distribution and publishing databases,
[quoted text clipped - 3 lines]
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message

Paul Ibison - 30 May 2006 16:04 GMT

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

Reply to this Message