Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Rename a cluster.. is it possible

 
   Database Forums (Home) -> Clustering RSS
Next:  SQL Server 2005 SP2 fails while installing perfor..  
Author Message
Hassan

External


Since: Nov 10, 2007
Posts: 28



(Msg. 1) Posted: Mon Dec 24, 2007 4:49 pm
Post subject: Rename a cluster.. is it possible
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

We have a single instance cluster on 2 nodes say SQL1. We want to do a
side-by-side upgrade of the underlying hardware and we have another cluster
with 2 nodes already ready and its called SQL2. At the time of cutover, we
want to just rename SQL1 to SQLOld and SQL2 back to SQL1 so that our
applications can connect to SQL1 without having to go through any connection
name changes.

Can it be done ? We've done many of these on standalone SQL instances by
renaming servers.. Wasnt too sure how it works on a cluster. Especially
since we are not dependent on the node names and the applications just
connect to the Virtual SQL instance, I was not too sure how to go about the
same.

Thanks

We are using SQL 2000...

Also in SQL 2005, is it the same or is it better to do this easily ?

 >> Stay informed about: Rename a cluster.. is it possible 
Back to top
Login to vote
Tom Moreau

External


Since: Apr 21, 2004
Posts: 441



(Msg. 2) Posted: Tue Dec 25, 2007 6:51 pm
Post subject: Re: Rename a cluster.. is it possible [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Why not just create a DNS alias and use that?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Hassan" wrote in message

We have a single instance cluster on 2 nodes say SQL1. We want to do a
side-by-side upgrade of the underlying hardware and we have another cluster
with 2 nodes already ready and its called SQL2. At the time of cutover, we
want to just rename SQL1 to SQLOld and SQL2 back to SQL1 so that our
applications can connect to SQL1 without having to go through any connection
name changes.

Can it be done ? We've done many of these on standalone SQL instances by
renaming servers.. Wasnt too sure how it works on a cluster. Especially
since we are not dependent on the node names and the applications just
connect to the Virtual SQL instance, I was not too sure how to go about the
same.

Thanks

We are using SQL 2000...

Also in SQL 2005, is it the same or is it better to do this easily ?

 >> Stay informed about: Rename a cluster.. is it possible 
Back to top
Login to vote
Hassan

External


Since: Nov 10, 2007
Posts: 28



(Msg. 3) Posted: Wed Dec 26, 2007 1:44 pm
Post subject: Re: Rename a cluster.. is it possible [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I guess we could, but also curious if a rename is possible too ?

"Tom Moreau" wrote in message

> Why not just create a DNS alias and use that?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Hassan" wrote in message
>
> We have a single instance cluster on 2 nodes say SQL1. We want to do a
> side-by-side upgrade of the underlying hardware and we have another
> cluster
> with 2 nodes already ready and its called SQL2. At the time of cutover, we
> want to just rename SQL1 to SQLOld and SQL2 back to SQL1 so that our
> applications can connect to SQL1 without having to go through any
> connection
> name changes.
>
> Can it be done ? We've done many of these on standalone SQL instances by
> renaming servers.. Wasnt too sure how it works on a cluster. Especially
> since we are not dependent on the node names and the applications just
> connect to the Virtual SQL instance, I was not too sure how to go about
> the
> same.
>
> Thanks
>
> We are using SQL 2000...
>
> Also in SQL 2005, is it the same or is it better to do this easily ?
>
 >> Stay informed about: Rename a cluster.. is it possible 
Back to top
Login to vote
Tom Moreau

External


Since: Apr 21, 2004
Posts: 441



(Msg. 4) Posted: Wed Dec 26, 2007 5:26 pm
Post subject: Re: Rename a cluster.. is it possible [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Check out:

http://msdn2.microsoft.com/en-us/library/ms178083.aspx

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Hassan" wrote in message

I guess we could, but also curious if a rename is possible too ?

"Tom Moreau" wrote in message

> Why not just create a DNS alias and use that?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Hassan" wrote in message
>
> We have a single instance cluster on 2 nodes say SQL1. We want to do a
> side-by-side upgrade of the underlying hardware and we have another
> cluster
> with 2 nodes already ready and its called SQL2. At the time of cutover, we
> want to just rename SQL1 to SQLOld and SQL2 back to SQL1 so that our
> applications can connect to SQL1 without having to go through any
> connection
> name changes.
>
> Can it be done ? We've done many of these on standalone SQL instances by
> renaming servers.. Wasnt too sure how it works on a cluster. Especially
> since we are not dependent on the node names and the applications just
> connect to the Virtual SQL instance, I was not too sure how to go about
> the
> same.
>
> Thanks
>
> We are using SQL 2000...
>
> Also in SQL 2005, is it the same or is it better to do this easily ?
>
 >> Stay informed about: Rename a cluster.. is it possible 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Rename Cluster Instance - Hi, I would like to rename a cluster name {network name} from INTSQL1 to lets say INTSQLVS whats the procedure ?

How SQL2005 cluster can be installed on windows cluster? - I am new on both SQL and windows cluster. Our company is trying to deploy a HA SQL system, which I need to install SQL2005 to windows cluster. My question is: Since windows cluster will share one back end storage chassis, where should I put SQL2005 on...

Cluster DR - My production cluster disks are corruptd - i would like to find out how to restore from backups I have all system backups and mdf and ldf files of the databases - I would like to keep the logins, jobs etc Thanks

Cluster SDK - Can someone point me out SDK for clustering on Win2000? I am planning to invoke Cluster API's using VBS... Thanks in adv.

SQL 2005 Cluster with 2K - Hi, I have a question that I hope someone can help me with (I've trawled the net...). I want to consolidate several SS 2K databases on to a new SS 2005 2 node cluster. I will use SS 2005 standard for the cluster. Is it possible to add a 2K instance....
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]