Home Forums SQL Server 2008 SQL Server 2008 Administration Whats the best way to move replication to the new sever ? RE: Whats the best way to move replication to the new sever ?

  • 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]