May 15, 2012 at 11:20 am
I will migrate SQL 2005 in Windows2003 cluster to SQL 2008 R2 cluster in Windows 2008 R2. Is it possible to rename virtural SQL server name to the old one once complete the migration? if not, will it work to create an alias in DNS to point to the new server. The reason I am asking is that there are lots of applications connecting to the databases on the SQL cluster server.
May 15, 2012 at 12:59 pm
Renaming the server is possible but could cause problems especially as you are looking at decomissioning the old server at the same time
A DNS alias will work. Any replication setup will need to use the actual name of the server and not the DNS alias. Everything else should be fine.
May 15, 2012 at 1:25 pm
I did something like this recently. It was a straight SQL 2008R2 to SQL 2008R2 move though due to a hardware replacement.
I brought up the new server with a new virtual name but the same instance name, the instance part is REALLY important because you can't rename the instance, only the virtual name without a re-install.
Once I had it running I changed the old servers virtual name to something else, thereby making the name available, and then renamed the virtual name on the new server. I also did the IP address at the same time.
When I was done the new server had the same name, instance name, ip address, and port. The old server had a new name and ip address, the instance name and port can remain the same.
CEWII
May 15, 2012 at 1:34 pm
Elliott Whitlow (5/15/2012)
I did something like this recently. It was a straight SQL 2008R2 to SQL 2008R2 move though due to a hardware replacement.I brought up the new server with a new virtual name but the same instance name, the instance part is REALLY important because you can't rename the instance, only the virtual name without a re-install.
Once I had it running I changed the old servers virtual name to something else, thereby making the name available, and then renamed the virtual name on the new server. I also did the IP address at the same time.
When I was done the new server had the same name, instance name, ip address, and port. The old server had a new name and ip address, the instance name and port can remain the same.
CEWII
We did a hardware replacement recently and just added the new servers to the existing cluster, installed SQL and failed over.
The old nodes were then evicted.
Was there another reason for your approach?
May 15, 2012 at 1:55 pm
MysteryJimbo (5/15/2012)
Elliott Whitlow (5/15/2012)
I did something like this recently. It was a straight SQL 2008R2 to SQL 2008R2 move though due to a hardware replacement.I brought up the new server with a new virtual name but the same instance name, the instance part is REALLY important because you can't rename the instance, only the virtual name without a re-install.
Once I had it running I changed the old servers virtual name to something else, thereby making the name available, and then renamed the virtual name on the new server. I also did the IP address at the same time.
When I was done the new server had the same name, instance name, ip address, and port. The old server had a new name and ip address, the instance name and port can remain the same.
CEWII
We did a hardware replacement recently and just added the new servers to the existing cluster, installed SQL and failed over.
The old nodes were then evicted.
Was there another reason for your approach?
Yes, normally I would have done exactly what you did, however, because of how our servers are housed I was unable to share the disks to the 2 new boxes, I could have added them to the cluster but SQL couldn't have been added to those nodes. So I had to do it a bit differently.
CEWII
May 15, 2012 at 1:58 pm
I have default instance not named instance. In my case it is not possible to rename it, right?
May 15, 2012 at 2:04 pm
Incorrect. Your SQL Server name is the virtual name so I don't see a problem..
In the case of a named instance the SQL Server name is the virtual name plus the Instance name.
In no case is it either of the nodes OR the cluster virtual name.
CEWII
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply