SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to rename a SQL Server 2005 Failover Clustered instance


How to rename a SQL Server 2005 Failover Clustered instance

Author
Message
APA0876
APA0876
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1052 Visits: 400
Hi ,
I neew to know how to rename a SQL Server 2005 Failover Clustered instance.
Thanks for all your assitance.
Thanks
Elliott Whitlow
Elliott Whitlow
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24976 Visits: 5314
The instance or the virtualname?

For the instance I know of know supported way other than re-install. Virtualname is actually pretty easy.

Which is it?

Also you posted this in the wrong forum.

CEWII
APA0876
APA0876
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1052 Visits: 400
As this is a cluster it will need to be the Virtual network name. This is a named instance which have this format:

Networkname\instancename

the new name will be:

NewNetworkname\instancename or should it be NewNetworknameewinstancename I want no name conflist

Basically I will migrate my systems from SQL Server 2005 to SQL Server 2008 R2 different cluster. And we need to keep the same instance name on the new servers so we need to remove from the dns the current names and also rename the instances before the new SQL Server 2008 installation.
We have the sql server 2005 clustered instance and a sql server local instance to migrate

Thanks
Elliott Whitlow
Elliott Whitlow
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24976 Visits: 5314
Ok, sorry I had gotten busy on other things.

Basically you have an side by side upgrade and you want the server names and instance names to be the same in the end. Right?

I have done this on windows 2008 r2, and this is roughly how I did it.

Build your SQL 2008 cluster with the same instance name as the SQL 2005 box, virtual name is unimportant since it isn't gonna be the final.

Do your upgrade.

Rename to virtual name of the SQL 2005 cluster to anything other than its name now. Change the IP address in the resource group to some other IP address. I would probably take the resource group offline.

On the SQL 2008 box change the virtual name to the name of the old SQL 2005 cluster, then change the ip address. I would probably set the port for SQL to the same as what the old SQL 2005 was using. Stop and restart SQL, it should now be using the new IP and virtual name.

You should now be able to decomission the SQL 2005 box on whatever timeline you want. Once that is done you will have to clean up the AD since the virtual name that the SQL 2005 box was using is not deleted.

CEWII
APA0876
APA0876
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1052 Visits: 400
Hi,
Thanks that's what we are planning - an upgrade to sql 2008 r2 keeping the same sql instance name to make this migration transparent to applications.

when you say create the SQL server cluster with same virtual name than the 2005. Can this be done while they both are on the same domain?

Well we were thinking to leave the sql server cluster installation for the migration day because if they are on the same domain there can't be identical names at the same time.

Virtual named instance with this format so this how it will look:

OriginalVirtualnetworkname\OriginalInstance

So my question is: Can I do it before the migration day with a temporary Virtual network name?
Thanks I will appreciate your advise also if you can provide the steps you followed so I can verify mine.
Thanks a lot
Elliott Whitlow
Elliott Whitlow
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24976 Visits: 5314
APA0876 (12/7/2012)
when you say create the SQL server cluster with same virtual name than the 2005. Can this be done while they both are on the same domain?

Please re-read, "Build your SQL 2008 cluster with the same instance name as the SQL 2005 box, virtual name is unimportant since it isn't gonna be the final."


Well we were thinking to leave the sql server cluster installation for the migration day because if they are on the same domain there can't be identical names at the same time.

No reason to wait, its better to have the new one up and ready and tested well before you are looking at a cutover. The won't have identical names until you change them, the instance names CAN be the same, they just can't be duplicated within a cluster. Virtual name must be unique on the network, but that name doesn't matter at this point.


Virtual named instance with this format so this how it will look:

OriginalVirtualnetworkname\OriginalInstance

So my question is: Can I do it before the migration day with a temporary Virtual network name?
Thanks I will appreciate your advise also if you can provide the steps you followed so I can verify mine.
Thanks a lot

On the network at the same time at the time of conversion you should have:
OriginalVirtualNetName\InstanceName
TemporaryVirtualNetName\InstanceName

After you migrate you will then change the original name and ip address to some other name/ip, this frees up that name/ip for use elsewhere. Using the old name/ip change the temporary name/ip to the old name/ip. Restart SQL and it will be using the previous name.

Clearer.

CEWII
Want a cool Sig
Want a cool Sig
Ten Centuries
Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)Ten Centuries (1,000 reputation)

Group: General Forum Members
Points: 1000 Visits: 705
Did the same thing 2005 to 2008 cluster. The virtual server names doesn't matter since it's just a DNS change it's the instance name that matters. The only names that can't be the same is the physical server names which won't matter anyways.
Not sure if it'll matter in your installation but it mattered in mine was the order in which I installed the instances. I wanted to keep the same path names (i.e. MSSQL.1, MSSQL.2 etc) since there were jobs writing files sub folders in those locations. I could have changed the jobs and such but it was easier to just make sure they had the same drive/path.

build the new cluster with temporary virtual server names and the same instance names. Then all you have to do is as you migrate all the DB's in that one instance turn off the old instance and rename the network name in the new one to match the old one... you can probably reassign the IP address as well if you need to.

---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar Hehe
I want a personal webpage Cool
I want to win the lotto :-D
I want a gf like Tiffa w00t Oh wait I'm married!:-D
Elliott Whitlow
Elliott Whitlow
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24976 Visits: 5314
You have to rename the old name or when you try and change the new server to the old name it will complain about a duplicate, it won't just take the name.

CEWII
APA0876
APA0876
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1052 Visits: 400
Thanks Again,

in the case of the default instance, then it will look like this:
OriginalVirtualNetworkName
TemporaryVirtualNetworkName

In the case of the Named Instance:
OriginalVirtualNetworkName\InstanceName
TemporaryVirtualNetworkName\InstanceName

Before the migration of course.

Thanks
Elliott Whitlow
Elliott Whitlow
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24976 Visits: 5314
Yes

CEWII
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search