[AlwaysOn] 創(chuàng)建SQL Server高可用性組T-SQL語法：FAILOVER_MODE參數(shù)

FAILOVER_MODE = { AUTOMATIC | MANUAL }

指定要定義的可用性副本的故障轉(zhuǎn)移模式。Specifies the failover mode of the availability replica that you are defining.

自動 AUTOMATIC

啟用自動故障轉(zhuǎn)移。Enables automatic failover. 只有當(dāng)您還指定了可用性模式為同步提交模式時，才支持此選項。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 故障轉(zhuǎn)移群集實例(FCI)不支持按可用性組進行自動故障轉(zhuǎn)移，因此只能為手動故障轉(zhuǎn)移配置由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

啟用數(shù)據(jù)庫管理員計劃的手動故障轉(zhuǎn)移或強制的手動故障轉(zhuǎn)移(通常稱為強制故障轉(zhuǎn)移)。Enables planned manual failover or forced manual failover (typically called forced failover) by the database administrator.

FAILOVER_MODE 子句是必需的。The FAILOVER_MODE clause is required. 在不同的條件下，支持兩種類型的手動故障轉(zhuǎn)移：不丟失數(shù)據(jù)的手動故障轉(zhuǎn)移和強制故障轉(zhuǎn)移(可能丟失數(shù)據(jù))。The two types of manual failover, manual failover without data loss and forced failover (with possible data loss), are supported under different conditions. 有關(guān)詳細信息，請參閱故障轉(zhuǎn)移和故障轉(zhuǎn)移模式(始終在可用性組上)。For more information, see Failover and Failover Modes (Always On Availability Groups).