Migrating from SQL 2005 on Windows 2003 Server to Sql 2008 on Windows 2008 Server - Can this be done with same server name?

Planning on migrating soon. Can't find any documentation on this. Have lots of touchpoints that would have to be modified if we have to change the server name. Can we take the 2005 server offline and then name the 2008 server with the same name and restore the 2005 databases to it? If so, are there any special requirements other than doing a standard maigration to a different server?
more ▼

asked Aug 02, 2011 at 12:52 PM in Default

kanangela77 gravatar image

21 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
It seems you are wanting to keep the same server name for name resolution? DNS, WINS, Active Directory all come into play when you wish to take one physical server offline and bring a new one online with the same name. You may find you need to remove the old server from the domain first, before joining the new one to the domain with the same physical name. If you can get around not having to have them the same name, then it will assist you with doing a side by side migration. All your user databases can be backed up and restored or detached and attached to the new server. Users, SSIS, DTS, linked servers, etc will all need to be scripted and moved over as well. You could also have your DNS guy just route the old A record to the new box at the time you shut it down. Just a thought.
more ▼

answered Aug 02, 2011 at 01:19 PM

Tim gravatar image

36.4k 38 41 139

(comments are locked)
10|1200 characters needed characters left
I guess you can do an upgrade of the operating system and then upgrade SQL server, but it is recommended to do a new install of OS and SQL server. I have done some upgrade of SQL server 2000/2005 to 2008 without problems, but I have not upgraded the OS.
more ▼

answered Aug 02, 2011 at 12:54 PM

Håkan Winther gravatar image

Håkan Winther
15.7k 35 37 48

I have a new physical server with the 2008 OS. So I would back up the dbs on the old server, take the server off the network, rename the new server to be that same as the old server and put it on the network, then restore the dbs in 2008. Doable?
Aug 02, 2011 at 01:03 PM kanangela77
(comments are locked)
10|1200 characters needed characters left

This is completely doable with no special requirements beyond a standard migration to a different server. It's called a Swing Migration - http://www.sbsmigration.com/pages/44/

You could actually build the new server with a new server name, so you have both servers alive at the same time for validation. Then, when it's cutover time, you rename the production server (or take it offline) and give the new server the production name.
more ▼

answered Aug 02, 2011 at 01:06 PM

KenJ gravatar image

20.3k 1 4 12

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 02, 2011 at 12:52 PM

Seen: 1395 times

Last Updated: Aug 02, 2011 at 12:52 PM