I have two node SQL Enterprise installed on a Windows 2003 cluster running
active -active. I would like to add a third node so that it would become 2
active and 1 passive . Is this feasible ?
Also , can someone tell me how can I make the third node standby for the
other two ? Do I have to install any binary and executable on the third node
/ modify the possible owner ?

Raymond

Look at "How to add nodes to an existing virtual server (Setup)" in BOL. It
gives a step by step on how to do it.

After you ran that, follow the steps in the Service Pack readme that you
have installed on the other nodes.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Norman" <raymond.chan (AT) hotmail (DOT) com> wrote

Norman

To control failover you can use the Preferred Owners List on the Group
Property sheets. However if you have a Windows 2003 Cluster you can implement
AntiAffintityClassNames to make absolutely certain that a node that is in a
passive role take ownership of a group in the event of a failure. See the
following KB for details on how to setup.

http://support.microsoft.com/default...;en-us;Q296799

Regards

CT

"Norman" wrote: