Server Migration - Replication setup

  • I have to migrate a production Sql Server 2000 (Ent Edition) Instance running on one box to another, as the current one is out of warranty. I plan to copy the user database files across and attach them on the new server. I will be restoring the msdb on B and manually migrating the logins/linked servers/other config settings to B.

    The challenge is to recreate the replication settings. For ex: lets us assume A be the old server and B the new server. Trans Replication is configured b/w a database X on A (publisher) to couple of other servers. Now we are using a remote distributor C to offload the processing activity off A and the distribution database as well as the distribution related jobs are located on C. Now if I rename the server B as A (after removing the old A from n/w) would the replication work? If not I need to configure all the replication settings from scratch.

  • Without knowing much about your configuration...

    I think it would be safer to set up your replication from scratch. You can use a 'nosynch' approach so you don't have to push out new snapshots.

    If you try a shortcut and something starts going wrong....you might have a lot of trouble.

    Graeme

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply