Upgrade a SQL Instance (side by side)

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 10, 2016 at 11:39 am

  #315538

  Hello Experts,

  I have a requirement to upgrade an old SQL Server 2008 R2 sql instance to SQL 2014/16.

  But users need the same instance name and ip address to be used in the new system.

  Question is -

  Can windows team change the existing server name / machine name to "server-old" and allocate a new Ip address and create another VM with the same name (servername) and with the ip address so that I can create the SQL Instance (default)? Upon successful migration, we can decommison the old one "server-old" or if I need to rollback, can bring back the old server by renaming it?

  Also, if windows team rename the machine with "server-old", as a DBA do I need to still do the below steps -

  SELECT @@servername

  EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘

  EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘local’

  SELECT @@servername

  Recycle SQL Server.

  Please suggest a smooth migration plan if you have done recently or sometime back.

  Thanks.

• rvsc48

  SSCertifiable

  Points: 7685

  More actions

  November 10, 2016 at 12:48 pm

  #1911769

  Hello, thinking the process would be similar to this:

  1) Windows team clones the existing Sql Server with a new (temporary) server name

  2) You, the dba, runs the code you have provided to rename Sql Server default instance to the new (temporary) server name

  3) You, the dba, upgrades the older instance on the new cloned machine to the new desired Sql Server version

  4) Decommission the old vm (freeing up the IP)

  5) Windows team renames the new server to the desired old name

  6) You, the dba, run the code you provided to rename Sql Server back to the old desired server name