FAILOVER_MODE = { AUTOMATIC | MANUAL }

专注于为中小企业提供成都网站设计、做网站服务,电脑端+手机端+微信端的三站合一,更高效的管理,为中小企业赤坎免费做网站提供优质的服务。我们立足成都，凝聚了一批互联网行业人才，有力地推动了1000多家企业的稳健成长，帮助中小企业通过网站建设实现规模扩充和转变。

指定要定义的可用性副本的故障转移模式。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 Cluster 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).

文章标题：[AlwaysOn]创建SQLServer高可用性组T-SQL语法：FAILOVER_MODE参数
分享网址：http://hbruida.cn/article/pisdop.html