Post reply

DB with transactional replication moving from server A to server B

  • February 10, 2010 at 3:05 pm

    #210860

    I have to move one of the servers with replicated database having 100's of publications and pushed subscriptions with transactional replication. I can do a restore with replication settings but will the replication pick up where it left off on the new server?

  • February 11, 2010 at 8:32 am

    #1117598

    We are also thinking of this as well.

    We have come up with a plan but we have not tested it yet.

    ServerA - Old Server

    ServerB - New Server

    Restore the DB on ServerB with the option of Keep replication. Rename ServerA to something else. Change the IP of ServerA.

    Rename ServerB to ServerA and change IP address to old IP of ServerA. Use sp_dropserver and sp_addserver to change the Server name in SQL for ServerB and then let it rip.

    We have not tested it yet. Keep us posted if you manage to do this.

    -Roy

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

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