网上看到有3个选项
我自己实际安装时,只有一个选项
但是手动创建可以支持dtc
USE [master]
GO
CREATE AVAILABILITY GROUP [test2016_2ag]
WITH (AUTOMATED_BACKUP_PREFERENCE = SECONDARY,
DB_FAILOVER = ON,
DTC_SUPPORT = PER_DB)
FOR DATABASE [test01]
REPLICA ON N'VWBJVWTSQLT0800' WITH (ENDPOINT_URL = N'TCP://SQLT0800:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, SESSION_TIMEOUT = 10, BACKUP_PRIORITY = 50, PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL), SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL)),
N'VWBJVWTSQLT0801' WITH (ENDPOINT_URL = N'TCP://SQLT0801:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, SESSION_TIMEOUT = 10, BACKUP_PRIORITY = 50, PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL), SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL)),
N'VWBJVWTSQLT0802' WITH (ENDPOINT_URL = N'TCP://SQLT0802:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, SESSION_TIMEOUT = 10, BACKUP_PRIORITY = 50, PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL), SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL));
GO
检查
2014不支持dtc