Move 2005 Distribution Server

• dt293

  Default port

  Points: 1412

  More actions

  January 3, 2008 at 3:02 am

  #177826

  Hi all,

  I am currently in the process of moving my dedicated SQL 2005 distribution server to a new machine.

  Can anyone point me in the direction of a best practice guide or have any tips on how to move the distribution services from the old to the new server without having to re-create all of the publications?

  I would also like to know how to re-configure the publishers to use the new distributor, is it a case of basically starting from scratch?

  Thanks

• Big Data Man

  SSCrazy Eights

  Points: 8536

  More actions

  January 4, 2008 at 5:02 am

  #764770

  Hey,

  Here's a starting point:

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