patternsqlMinor
DTC and AlwaysOn
Viewed 0 times
anddtcalwayson
Problem
We're heading into a new infrastructure:
HyperV, Violin storage & dualsite setup
We're looking into AlwaysOn for dual site, but we are using DTC on many of our systems.
Do you know if the issues with SQL2014 AlwaysOn/DTC only are releated to syncronous AG's?
HyperV, Violin storage & dualsite setup
We're looking into AlwaysOn for dual site, but we are using DTC on many of our systems.
Do you know if the issues with SQL2014 AlwaysOn/DTC only are releated to syncronous AG's?
Solution
Do you know if the issues with SQL2014 AlwaysOn/DTC only are releated to syncronous AG's?
There is a limited support for DTC with AlwaysON running SQL Server 2016 Community Technology Preview 2 (CTP2). See : Cross-Database Transactions Support For Database Mirroring or AlwaysOn Availability Groups (SQL Server)
For SQL Server 2014 and earlier, DTC is not supported for AlwaysON or DB Mirroring.
Also, refer to Brent's answer : AlwaysOn AG, DTC with failover
There is a limited support for DTC with AlwaysON running SQL Server 2016 Community Technology Preview 2 (CTP2). See : Cross-Database Transactions Support For Database Mirroring or AlwaysOn Availability Groups (SQL Server)
For SQL Server 2014 and earlier, DTC is not supported for AlwaysON or DB Mirroring.
Also, refer to Brent's answer : AlwaysOn AG, DTC with failover
Context
StackExchange Database Administrators Q#114606, answer score: 4
Revisions (0)
No revisions yet.