Any CONS Replacing a server with a new one?

• Raul Undreiner

  SSCommitted

  Points: 1554

  More actions

  April 25, 2008 at 8:44 am

  #121336

  We want to replace one of our servers 32bits with a 64bits SQL Server 2005 that is called SERVER64 without causing any problems to users. Our actual Server is called SERVER32 and what we are planning to do is to put offline SERVER32, backup all databases, detach the server from the network, have the new machine renamed as SERVER32 and attach it to the network.

  Restore all databases and create all LOGINS from the old server.

  Am I missing something here? Is that it?

  What happens with the service users created by SQL Server install? any problems with those?

  Thanks for your help

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 25, 2008 at 9:13 am

  #807235

  This is a cross post. Please post any comments/answers here.

  Raul, please post once so people don't waste time answering in 2 places.

  Thanks,

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question