Rename a cluster.. is it possible

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 ?
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" <hassan@.test.com> wrote in message
news:OI5fRApRIHA.1212@.TK2MSFTNGP05.phx.gbl...
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 ?
|||I guess we could, but also curious if a rename is possible too ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OvufTE1RIHA.5136@.TK2MSFTNGP04.phx.gbl...
> 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" <hassan@.test.com> wrote in message
> news:OI5fRApRIHA.1212@.TK2MSFTNGP05.phx.gbl...
> 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 ?
>
|||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" <hassan@.test.com> wrote in message
news:u2ulJiASIHA.5128@.TK2MSFTNGP05.phx.gbl...
I guess we could, but also curious if a rename is possible too ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OvufTE1RIHA.5136@.TK2MSFTNGP04.phx.gbl...
> 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" <hassan@.test.com> wrote in message
> news:OI5fRApRIHA.1212@.TK2MSFTNGP05.phx.gbl...
> 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 ?
>