Perry Whittle (4/16/2013)

---

SQLSACT (4/16/2013)

---

Because Node1 has SQL installed as nonclustered, is it safe to say that it's not absolutely necessay to share DTC across all 3 nodes.

yes you could argue that. But since all 3 nodes are in the same cluster on the same site the DTC resource would be even more highly available. It depends on your requirements for DTC, also under Windows 2008 you may now have multiple DTC resources whereas you couldn't under Windows 2003.

SQLSACT (4/16/2013)

---

If I failover my AG to Node1, if DTC is needed when the AG is running on Node1, won't it just use the DTC service on that server?

Thanks

Yes, but what about an inflight transaction that was in process at the time, that will not be recoverable by the local DTC.

Yes, but what about an inflight transaction that was in process at the time, that will not be recoverable by the local DTC