SQLSACT (4/16/2013)
Hi AllMy Setup:
>> 3 Servers (Node1-Node2-Node3) all part of the same Cluster "Cluster1"
>> SQL installed as clustered on Node2 & Node3, producing "SQLCluster"
>> SQL installed as nonclustered on Node1, producing "Node1\SQL"
>> Availability Group has been set up between "SQLCluster" & "Node1\SQL"
Looks ok to me
SQLSACT (4/16/2013)
Quorum: What is the recommended Quorum configuration for my setup, I'm assuming Node majority.
Correct, for a 3 node cluster node majority is recommended.
Do the servers span multiple sites at all?
SQLSACT (4/16/2013)
DTC: Should all the nodes be a possible owner of DTC? Should the DTC disk be presented to all the nodes?
Yes and yes.
SQLSACT (4/16/2013)
Failover: When configuring the failover mode, I am unable to change it to Automatic, is Automatic failover not supported when you combine an AG with an FCI or am I missing something?Thanks
This link details the following
FCIs do not support automatic failover by availability groups: FCIs do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can be configured for manual failover only.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉