• SQLSACT (4/16/2013)


    By this do you mean it's not part of the storage allocated to the clustered instance of SQL Server?

    Yep, MSDTC has absolutely nothing to do with SQL Server, SQL Server makes use of it for remote transactions but then so do other Windows services.

    SQLSACT (4/16/2013)


    Currently my DTC is part of the cluster but not part of the SQL group in the cluster, however, the DTC disk has only been presented to Node2 & Node3 - Node1 has it's own DTC disk, which I realize now is moot.

    With all nodes on one site it would make sense to have the DTC available on as many nodes as possible

    SQLSACT (4/16/2013)


    My storage setup is as follows

    I: Drive presented to Node2 & Node3 - For SQL data and log files

    X: Drive Drive presented to Node2 & Node3 for DTC

    I: Drive presented only to Node1 - For SQL data and log files

    X: Drive presented only to Node1 for DTC

    Corrections?

    For the instance, no, makes sense to have the same drive letter and datafile paths.

    DTC i would fail across all nodes, but it's your choice

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉