安装sql server 2016 always on配置dtc支持时遇到的问题-白红宇

安装sql server 2016 always on配置dtc支持时遇到的问题

阅读量：6306 次

发布时间：2019-06-22

本文共 1048 字，大约阅读时间需要 3 分钟。

网上看到有3个选项

我自己实际安装时，只有一个选项

但是手动创建可以支持dtc

USE [master]GOCREATE 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

转载于:https://www.cnblogs.com/godspeed034/p/7088537.html

你可能感兴趣的文章

编程，将2000年到3000年之间的闰年年号输出

查看>>

JavaScript中call,apply,bind方法的总结。

查看>>

PCI passthrough in nested virtualization (rhel7)

查看>>

jenkins集成sonarqube

查看>>