Add a third node to a cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Norman - 27 May 2005 22:44 GMT

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

Reply to this Message

Mike Epprecht \(SQL MVP\) - 27 May 2005 23:18 GMT

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@epprecht.net

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

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

>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
[quoted text clipped - 4 lines]
>
> Raymond

Reply to this Message

Charles Tolento - 31 May 2005 23:39 GMT

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.aspx?scid=kb;en-us;Q296799

Regards

CT

> 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
[quoted text clipped - 4 lines]
>
> Raymond

Reply to this Message