I was planning to create a two node AG on SQL Server 2012, but the Distributed Transaction Coordinator is in use on the system I want to migrate to the AG. Right now it is a stand alone instance, but the system used to be a two node failover cluster. According to this
link, DTC with AG can result in data loss. If we use a two node failover cluster instance, would we not have the same risk of data loss since we would still have two separate nodes with separate DTC processes running? It seems like perhaps Log Shipping is my only option here. Looking for recommendations, other than update it to SQL Server 2017, where DTC is fully supported. For right now, updating the SQL Server instance isn't really an option.