Can one deploy a 2 node cluster with an instance on each node and the
failover node be the other? Like node A & node B, A's instance fails to B
and B's instance fails to A?
--
Thanks,
John

Yes, you can. This is allowable.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

"John - PDX" <JohnPDX (AT) discussions (DOT) microsoft.com> wrote

In effect, you could run 8 instances on each node, with a maximum of 16 per
cluster.

Just make sure you configure SQL Server to not use all the memory on one
node, as during a failover, the other instance needs RAM too.

Regards
Mike

"Rodney R. Fournier [MVP]" wrote:

As Mike and Rodney indicated, you can run up to 16 instances on a cluster
and divide them however you choose. To choose, you set the preferred host
order for each SQL resource group using the cluster admin tool. As Mike
warned, you must plan for all instances to "collapse" onto a single node
duriing a failover situation.

Here is a useful KB article that covers Memory allocation on a cluster along
with a lot o other very good topics.

Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default...b;en-us;254321


Geoff N. Hiten
Microsoft SQL Server MVP


"John - PDX" <JohnPDX (AT) discussions (DOT) microsoft.com> wrote