Making copy of old Server

• Momak

  Say Hey Kid

  Points: 687

  More actions

  November 20, 2005 at 8:04 am

  #166064

  Hello everybody,

  we move our application to a different location in new hardware environment, so I want to prepare everything and than to turn off primary server, change name of the new one and than to start new server to work with application.

  My question is:

  - I will instal MS SQL Server Enterprise Ed. in new location and prepare everything for our application. When I want to move application and make the new server productional do I need to do anything else but to turn off old server, change name of new one and than to execute on new server:

  master..sp_dropserver 'InitialName'

  master..sp_addserver 'NameOfOldProduction', LOCAL

  Is there any other update of system tables, or changing in registry, or smth else.

  Thanks in advance

• K. Brian Kelley

  SSC Guru

  Points: 114562

  More actions

  November 20, 2005 at 11:40 am

  #604831

  You'll want to take a look at the following in order to get the databases/security principals moved successfully.

  HOW TO: Move Databases Between Computers That Are Running SQL Server (314546)

  K. Brian Kelley
  @kbriankelley