Publisher change the server - the easiest way to do ?

• Momak

  Say Hey Kid

  Points: 687

  More actions

  October 25, 2005 at 5:30 am

  #166482

  This is very important.

  I have merge replication with publisher and distributor on the same server and about 20 Subscribers all over the country.

  We are moving to another building, with new equipment, so Publisher will be on different server. How to make this move easily, without recreating new publication and pushing new subscribers and implementing initial snapshot, because it will destroy my network.

  Is there any possibility to do something like attach/detach DB (distibution and source DB), do few steps more, and to have all like it was before.

  Must be.

  Thanks in advance.

• Chrislis

  SSChasing Mays

  Points: 622

  More actions

  October 26, 2005 at 8:23 am

  #600193

  I'm sure there must be a topic on this forum about this but you can also try this link:

  http://vyaskn.tripod.com/moving_sql_server.htm