[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 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).