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

FAILOVER_MODE = { AUTOMATIC | MANUAL }
指定要定义的可用性副本的故障转移模式。Specifies the failover mode of the availability replica that you are defining.

自动 AUTOMATIC
启用自动故障转移。Enables automatic failover. 只有当您还指定了可用性模式为同步提交模式时，才支持此选项。This option is supported only if you also specify AVAILABILITY_MODE = SYNCHRONOUS_COMMIT. 可以为两个可用性副本(包括主副本)指定自动。You can specify AUTOMATIC for two availability replicas, including the primary replica.
注释 Note
SQL Server
故障转移群集实例(FCI)不支持按可用性组进行自动故障转移，因此只能为手动故障转移配置由FCI承载的任何可用性副本。SQL Server Failover C免费云主机域名luster Instances (FCIs) do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can only be configured for manual failover.

手动 MANUAL
启用数据库管理员计划的手动故障转移或强制的手动故障转移(通常称为强制故障转移)。Enables planned manual failover or forced manual failover (typically called
forced failover) by the database administrator.
FAILOVER_MODE
子句是必需的。The FAILOVER_MODE clause is required. 在不同的条件下，支持两种类型的手动故障转移：不丢失数据的手动故障转移和强制故障转移(可能丢失数据)。The two types of manual failover, manual failover without data loss and forced failover (with possible data loss), are supported under different conditions. 有关详细信息，请参阅故障转移和故障转移模式(始终在可用性组上)。For more information, see

Failover and Failover Modes (Always On Availability Groups).

相关推荐: Oracle等待事件之enq: TM – contention

执行DML 期间，为防止对与DML 相关的对象进行修改，执行DML 的进程必须对该表获得TM 锁。P1 = name|modeP2 = object #P3 = table/partitionSQL> select name,parameter1,par…