March 6, 2009 at 1:35 pm
I have a project to migrate SQL server databases in our data warehouse from one cluster to a new cluster (due the hardware refresh). The original cluster was two-node, active/passive with direct-attached SCSI array storage. The new cluster will be active/passive, but the storage will be on a SAN. The important constraint I have is I need to use the same SQL virtual server name in the new cluster. Has anyone done a SQL server virtual server rename? Had any issues with renaming the virtual server? I am planning to build the new cluster with a different name, then after the databases have been moved rename the virtual server to be the same as the original (with the original cluster shutdown first). Any advice would be greatly appreciated.
March 13, 2009 at 8:28 am
we did this last year
backup
detach databases from current sql instance
uninstall sql on old cluster
install sql on new cluster
attach databases
create logins, jobs, replication, etc
March 13, 2009 at 9:44 am
Accorinding to Microsoft and BOL the only way to change the SQL Cluster virtual name is to re-install the SQL cluster.
I don't think you will be able to install SQL to the new cluster, called say "new cluster" and then at some point down the line call it "oldcluster" , the name of the orginal clsuter without a complete re-install of SQL
Gethyn Elliswww.gethynellis.com
March 13, 2009 at 9:55 am
I was hoping that someone had actually done a rename of a virtual server name following the BOL article http://msdn.microsoft.com/en-us/library/ms178083(SQL.90).aspx
My concern is that it's one thing to see it in an article, but another to hear from someone that has done it successfully. Looks like I am going the route of an uninstall,,,,,install into the new cluster.
Thanks for the responses.
March 13, 2009 at 4:16 pm
Hi Just to back up what i said earlier, i read this in an article written by Brad McGehee on another site
Now, here is a very important step. This is when you enter the name of the virtual SQL Server 2005 instance you are currently installing. This is the name that clients will use to connect to this instance. Ideally, you have already selected a name to use that makes the most sense to your organization. Click Next to proceed. If you ever need to change this virtual name, you will have to uninstall and then reinstall SQL Server 2005 clustering.
http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p2.aspx
I have been facing a similar situation when i read this i concluded that the uninstall reinstall would be the only option. If you do get this done successfully without uninstallation i'd be more than interested to find out
Gethyn Elliswww.gethynellis.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply