[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 .
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-2654025/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:BASIC引數SQLServer
- [AlwaysOn] 建立SQL Server AlwaysOn高可用性組T-SQL語法SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:DISTRIBUTED引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:BACKUP_PRIORITY引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:CLUSTER_TYPE引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:DTC_SUPPORT引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:group_name引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:SESSION_TIMEOUT引數SQLServerSession
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:SEEDING_MODE引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:AVAILABILITY_MODE引數SQLServerAI
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:DB_FAILOVER引數SQLServerAI
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:AUTOMATED_BACKUP_PREFERENCE引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:HEALTH_CHECK_TIMEOUT引數SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:FAILURE_CONDITION_LEVEL引數SQLServerAI
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:LISTENER子句SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:DATABASE子句SQLServerDatabase
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:例項SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:REPLICA ON子句SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:安全性SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:AVAILABILITY GROUP ON子句SQLServerAI
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:ENDPOINT_URL子句SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:PRIMARY_ROLE子句SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:SECONDARY_ROLE子句SQLServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:先決條件和限制SQLServer
- [AlwaysOn] T-SQL語法:REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT引數SQLUIsynchronizedMIT
- SQL Server 2022 AlwaysOn新特性之包含可用性組介紹SQLServer
- [AlwaysOn] AlwaysOn可用性組的可用性模式之間的差異模式
- T-SQL——基礎語法SQL
- SQL Server AlwaysOn可用性副本會話期間的可能故障SQLServer會話
- SQL Server Alwayson建立代理作業注意事項SQLServer
- SQL Server AlwaysOn搭建SQLServer
- SQL Server中的高可用性概覽SQLServer
- 15 個常用的 SQL Server 高階語法SQLServer
- T-SQL的CREATE TABLE語法(下)SQL
- T-SQL的CREATE TABLE語法(上)SQL
- 【T-SQL】〇、 T-SQL語法說明SQL
- SQL Server資料庫管理常用SQL和T-SQL語句SQLServer資料庫
- 雲中SQL Server高可用性最佳實踐SQLServer