• SQLSACT (4/16/2013)


    Hi All

    My 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" 😉