[AlwaysOn] 建立SQL Server高可用性組T-SQL語法:FAILOVER_MODE引數

cow977發表於2019-08-18

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 .


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-2654025/,如需轉載,請註明出處,否則將追究法律責任。

相關文章