Seamless AOAG failover with DTC?

0 votes

1 answer

40 views

sql-server availability-groups distributed-transactions

                          With SQL Server 2017 and higher, can using "Per Database DTC Support" help mitigate disruptions to connected applications or will the queries running on Node1 at time of failover to Node2 error out? Is there any way to gracefully "hand off" running transactions from node to node?
                        

Asked by Alex Pixley (43 rep)

Aug 21, 2024, 07:25 PM
Last activity: Aug 21, 2024, 09:56 PM

Seamless AOAG failover with DTC?

Related Questions