<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
How to rename a SQL Server 2005 Failover...
12 posts, Page 1 of 2
1
2
»»
How to rename a SQL Server 2005 Failover Clustered instance
Rate Topic
Display Mode
Topic Options
Author
Message
APA0876
APA0876
Posted Wednesday, December 05, 2012 12:49 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 1:46 PM
Points: 112,
Visits: 255
Hi ,
I neew to know how to rename a SQL Server 2005 Failover Clustered instance.
Thanks for all your assitance.
Thanks
Post #1393176
Elliott Whitlow
Elliott Whitlow
Posted Wednesday, December 05, 2012 1:06 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 5,870,
Visits: 4,893
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
Post #1393182
APA0876
APA0876
Posted Wednesday, December 05, 2012 2:15 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 1:46 PM
Points: 112,
Visits: 255
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
Post #1393208
Elliott Whitlow
Elliott Whitlow
Posted Friday, December 07, 2012 8:40 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 5,870,
Visits: 4,893
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
Post #1394086
APA0876
APA0876
Posted Friday, December 07, 2012 1:54 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 1:46 PM
Points: 112,
Visits: 255
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
Post #1394233
Elliott Whitlow
Elliott Whitlow
Posted Friday, December 07, 2012 2:11 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 5,870,
Visits: 4,893
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
Post #1394243
Want a cool Sig
Want a cool Sig
Posted Friday, December 07, 2012 3:20 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:20 AM
Points: 225,
Visits: 462
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 - Future MCM 2025
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar
I want a personal webpage
I want to win the lotto
I want a gf like Tiffa
Post #1394269
Elliott Whitlow
Elliott Whitlow
Posted Friday, December 07, 2012 3:23 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 5,870,
Visits: 4,893
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
Post #1394271
APA0876
APA0876
Posted Friday, December 07, 2012 7:06 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 1:46 PM
Points: 112,
Visits: 255
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
Post #1394294
Elliott Whitlow
Elliott Whitlow
Posted Saturday, December 08, 2012 11:43 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 5,870,
Visits: 4,893
Yes
CEWII
Post #1394348
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
