none
MSDTC and SQL 2012 AlwaysOn Availability Groups

    Question

  • Hi,

    This link http://technet.microsoft.com/en-us/library/ms366279.aspx said distributed transactions are not supported by AlwaysOn Availability Groups.

    Does “Not Supported” mean you cannot enlist a distributed transaction at all?

    Or “Not Supported” means do not guarantee the atomicity/integrity of automatic failover. In that case, I think I can use manual failover mode. Not using MSDTC is not an option for us.

    Thanks for any help.

    Lijun

    Tuesday, October 15, 2013 6:14 PM

Answers