[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：DB_FAILOVER参数

DB_FAILOVER = { ON | OFF }

指定主副本上的数据库脱机时要采取的响应。Specifies the response to take when a database on the primary replica is offline. 当设置为“ON”时，可用性组中数据库的任何非联机状态都会触发自动故障转移。When set to ON, any status other than ONLINE for a database in the availability group triggers an automatic failover.当此选项设置为OFF时，仅使用实例的运行状况触发自动故障转移。When this option is set to OFF, only the health of the instance is used to trigger automatic failover.

有关此设置的详细信息，请参阅数据库级健康检测选项。For more information regarding this setting, see Database Level Health Detection Option.