A Question on SQL Cluster -Urgent

We are planning the following setup as part of our Business Continuity
Planning.
We have an active passive cluster in the production and we will also have
the same setup in the DR setup. But the issue is that we need to keep the
same SQL virtual name in both Production and DR. So in this scenario if we
have to do some maintenance on the DR setup for eg: to apply Service Packs
or any fine tuning, how do we do that? Is there any recommendation or best
practices?
Waiting on an immediate response.
Abhi
Consider using a DNS alias. The apps use the alias, while the virtual
servers can be whatever you want.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Abhi" <Abhi@.discussions.microsoft.com> wrote in message
news:F4A782D4-8BD3-4B46-ABFA-B6BECE82908D@.microsoft.com...
We are planning the following setup as part of our Business Continuity
Planning.
We have an active passive cluster in the production and we will also have
the same setup in the DR setup. But the issue is that we need to keep the
same SQL virtual name in both Production and DR. So in this scenario if we
have to do some maintenance on the DR setup for eg: to apply Service Packs
or any fine tuning, how do we do that? Is there any recommendation or best
practices?
Waiting on an immediate response.
Abhi
|||"Abhi" <Abhi@.discussions.microsoft.com> wrote in message
news:F4A782D4-8BD3-4B46-ABFA-B6BECE82908D@.microsoft.com...
> We are planning the following setup as part of our Business Continuity
> Planning.
> We have an active passive cluster in the production and we will also have
> the same setup in the DR setup. But the issue is that we need to keep the
> same SQL virtual name in both Production and DR. So in this scenario if we
> have to do some maintenance on the DR setup for eg: to apply Service
> Packs
> or any fine tuning, how do we do that? Is there any recommendation or best
> practices?
You might also consider using database mirroring.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
July 10-13 in Denver
July 16-19 in New York
Sep 3 - 6 in Copenhagen