Thursday, March 22, 2012

Active\Passive to Active\Active

Does this means.. if we have 2 instances on active/passive cluster... we can
make it active/active by just moving one instance on the other node. Thats
it.. correct? Thanks in advance for your reply.
"Geoff N. Hiten" wrote:

> Tom is trying very hard to answer your question.
> You have a Single-instance, two-node cluster. The 'Active/Passive'
> nomenclature went away with SQL 7.0 when clustering setup and functionality
> changed drastically. You can add more instances to your cluster. Each
> Instance will act as an independent SQL Server. You cannot have two host
> nodes "share" a set of databases and scale out that way.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:B69A7772-DC00-40B9-AFEA-7354393ADEAA@.microsoft.com...
>
"DBA05" <DBA05@.discussions.microsoft.com> wrote in message
news:43794BBE-EDA5-4F67-AAD4-8BFF835071C1@.microsoft.com...
> Does this means.. if we have 2 instances on active/passive cluster... we
> can
> make it active/active by just moving one instance on the other node. Thats
> it.. correct? Thanks in advance for your reply.
Yes.
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:
Dec 10 - 13 in Denver
Jan 18 - 31 in Denver
|||Is it possible to change name of SQL Server Instance on Cluster? If yes, what
is the appropriate way to do it?
Thanks.
"Russ Kaufmann [MVP]" wrote:

> "DBA05" <DBA05@.discussions.microsoft.com> wrote in message
> news:43794BBE-EDA5-4F67-AAD4-8BFF835071C1@.microsoft.com...
> Yes.
>
> --
> 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:
> Dec 10 - 13 in Denver
> Jan 18 - 31 in Denver
>
|||You cannot rename an instance if it is clustered:
http://support.microsoft.com/kb/260414
(See question 5.) You would have to reinstall.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"DBA05" <DBA05@.discussions.microsoft.com> wrote in message
news:57FBF475-5224-4FA7-A217-DC94147C63D5@.microsoft.com...
Is it possible to change name of SQL Server Instance on Cluster? If yes,
what
is the appropriate way to do it?
Thanks.
"Russ Kaufmann [MVP]" wrote:

> "DBA05" <DBA05@.discussions.microsoft.com> wrote in message
> news:43794BBE-EDA5-4F67-AAD4-8BFF835071C1@.microsoft.com...
> Yes.
>
> --
> 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:
> Dec 10 - 13 in Denver
> Jan 18 - 31 in Denver
>

No comments:

Post a Comment