Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-07-31 : 10:14:39
|
Hello,I have a question. We are moving databases to new servers at a new physical location. The new physical servers are currently named differently than the current production servers (because they're on the same domain). We have however already installed SQL Server 2000 on these new servers as named instances (ex. p-corp-amsdb-0a\VS001). These servers are also on a cluster.On the day that we cutover to the new servers the server ops admins are going to rename the physical servers at the new location to their original name and shut down the old ones. My question is how do I rename the named instance from p-corp-amsdb-0a\VS001 to corp-amsdb-001\VS001? Keep in mind these are on a cluster as well. I'm hoping this can be done without having to uninstall/reinstall SQL Server 2000 on the cluster.Any help would be greatly appreciated!Thanks,Dustin |
|
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-07-31 : 11:00:37
|
I'm thinking that because these are named instances and not default instances I can just simply perform the following after the servers have been renamed.http://msdn.microsoft.com/en-us/library/aa197071(SQL.80).aspxCan someone please confirm that this is correct?Thanks!Dustin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-31 : 22:44:10
|
No, you can't rename named instance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-01 : 01:02:27
|
On a cluster, you don't use the physical server names when dealing with SQL Server. SQL Server uses the virtual server name.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-08-01 : 08:19:07
|
So if the virtual server names change will I need to do anything with the named instances, or will it take care of itself? The name of the actual instances aren't changing, only the server name that precedes the instance name will change.Thanks for the input! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-01 : 23:25:54
|
If you rename physical node's name, it'll not affect sql instance since instance name on cluster is virtual_sql_name\instance_name. If you rename virtual sql name, then instance will be new_virtual_name\instance_name. |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-08-04 : 01:47:52
|
Lets have a look at the below scenario, with description. The physical node names are the cluster node 1 & cluster node 2. If you change that it will not affect the sql instance. SQL instance depends on the virtual server name(SQL Server Network Name).CLS001 ## Cluster node 1 (Primary Node)CLS002 ## Cluster node 2 (Failover Node)CLSQL001A\CLSQL001AInstance ## SQL Network Name 2CLSQL001B ## SQL Network Name 1CLSQL001 ## Cluster NameIf you rename the SQL Server Network Name resource,the SQL Server virtual server instance may no longer come online.The correct way to rename a clustered SQL Server 2000 virtual server is to remove and then reinstall SQL Server 2000 by using the new virtual server name.http://support.microsoft.com/kb/307336SQL Server 2005---------------This is not true here.ie., we can rename virtual server. Refer the link pls...http://msdn.microsoft.com/en-us/library/ms178083.aspxThanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
|