Post reply

Whats the best way to move replication to the new sever ?

  • July 9, 2014 at 8:35 pm

    #309055

    Hi,

    We are moving one of the DB to a new server. Both are installed with SQL Server 2005 with SP4.

    Replication has been setup for some of the tables in source server.

    Whats the best way to move replication to the new sever ?

    Thanks in advance,

    Smith

  • July 9, 2014 at 11:44 pm

    This was removed by the editor as SPAM

  • July 10, 2014 at 1:14 am

    #1728286

    Thanks a lot. Lets check the link.

  • July 10, 2014 at 2:15 am

    #1728292

    prettsons (7/9/2014)

    The easiest way is to simply resetup the replication.

    If you don’t like that answer…

    Backup the publishing database and restore it to the new publisher with the KEEP_REPLICATION flag enabled.

    Continue reading Denny Cherry post on below thread:

    http://itknowledgeexchange.techtarget.com/itanswers/migrating-sql-server-replication-from-one-server-to-another/%5B/quote%5D

    If only it was that simple. What about registering the publisher at the distributor? Enabling replication on the new publisher? Simply restoring with keep_replication will not work.

    Its far safer and cleaner to ensure there are no active data changes, script out replication, drop existing replication and set it backup on the new server without re-initialising the subscriber.

  • July 10, 2014 at 3:02 am

    #1728299

    MysteryJimbo (7/10/2014)

    If only it was that simple. What about registering the publisher at the distributor? Enabling replication on the new publisher? Simply restoring with keep_replication will not work.

    Its far safer and cleaner to ensure there are no active data changes, script out replication, drop existing replication and set it backup on the new server without re-initialising the subscriber.

    +1. Replication can be fiddly to create at the best of times. If your database(s) aren't too large you can get away with a snapshot and reinitialise however larger dbs you definitely want to to perform backup restore then apply replication.

    Lots of work on hey, Joy? 😉

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

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