Groups | Blog | Home
all groups > sql server clustering > october 2007 >

sql server clustering : Active\Passive to Active\Active


Mike
10/24/2007 3:04:00 PM
How can we convert our SQL Server 2000 (Windows Server 2003 R2)
Active\Passive cluster to Active\Active?

Thank you.
--
Mike
10/24/2007 3:17:01 PM
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


[quoted text, click to view]
Russ Kaufmann [MVP]
10/24/2007 4:08:16 PM
[quoted text, click to view]

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
Mike
10/24/2007 7:09:00 PM
Could you please answer my questions. Your help would be greatly
appreciated.

Thank you.
--
Mike


[quoted text, click to view]
Tom Moreau
10/24/2007 8:58:14 PM
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


[quoted text, click to view]
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


[quoted text, click to view]
Geoff N. Hiten
10/24/2007 10:17:16 PM
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





[quoted text, click to view]
AddThis Social Bookmark Button