MSDTC Recommendations on SQL Failover Cluster
First published on MSDN on Jan 15, 2014 The purpose of the following FAQ (Frequently Asked Questions) is to address common questions with MSDTC (Microsoft Distributed Transaction Coordinator) when used with SQL Server Failover Clustered instances to include current recommendations and best practices.Not-Supported: AGs With DTC/Cross-Database Transactions
First published on MSDN on Jan 06, 2014 When the topic of cross-database and/or DTC transaction support, under an Availability Group, comes up the quick response is NOT SUPPORTED! This is a true statement and the conversation tends to then focus on – ‘but why'?’ In fact, some DBAs have tested various forms of these transaction types and not encountered errors.
