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

cow977發表於2019-08-13

DB_FAILOVER = { ON | OFF }

指定主副本上的資料庫離線時要採取的響應。Specifies the response to take when a database on the primary replica is offline. 當設定為“ON”時,可用性組中資料庫的任何非聯機狀態都會觸發自動故障轉移。When set to ON, any status other than ONLINE for a database in the availability group triggers an automatic failover.當此選項設定為OFF時,僅使用例項的執行狀況觸發自動故障轉移。When this option is set to OFF, only the health of the instance is used to trigger automatic failover.

有關此設定的詳細資訊,請參閱資料庫級健康檢測選項。For more information regarding this setting, see .


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

相關文章