How can we convert our SQL Server 2000 (Windows Server 2003 R2)
Active\Passive cluster to Active\Active?

Thank you.
--
Mike

"Mike" <Mike (AT) discussions (DOT) microsoft.com> wrote

Install another instance and run it on the other node.


--
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 21 - 24 in New York

Please forgive my ignorance, but are you saying to install another instance
(active) on the passive node? If so, can we then remove the passive
instance? If so, how should we do this?

Thank you again for your help.
--
Mike


"Mike" wrote:

You don't install instances onto nodes. You install them onto the cluster.
The instance can run on whatever node you like. We don't use the terms
Active and Passive any more.

--
Tom

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


"Mike" <Mike (AT) discussions (DOT) microsoft.com> wrote

Please forgive my ignorance, but are you saying to install another instance
(active) on the passive node? If so, can we then remove the passive
instance? If so, how should we do this?

Thank you again for your help.
--
Mike


"Mike" wrote:

Could you please answer my questions. Your help would be greatly
appreciated.

Thank you.
--
Mike


"Tom Moreau" 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 (AT) discussions (DOT) microsoft.com> wrote

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:

"DBA05" <DBA05 (AT) discussions (DOT) microsoft.com> wrote

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:

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 (AT) discussions (DOT) microsoft.com> wrote

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: