AvailabilityGroupFailureConditionLevel AvailabilityGroupFailureConditionLevel AvailabilityGroupFailureConditionLevel Enum

Definition

Specifies the different conditions that can trigger an automatic failover in Availability Group.

public enum class AvailabilityGroupFailureConditionLevel
[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.AvailabilityGroupFailureConditionLevelConverter))]
public enum AvailabilityGroupFailureConditionLevel
Public Enum AvailabilityGroupFailureConditionLevel
Inheritance
AvailabilityGroupFailureConditionLevelAvailabilityGroupFailureConditionLevelAvailabilityGroupFailureConditionLevel
Attributes

Fields

OnAnyQualifiedFailureCondition OnAnyQualifiedFailureCondition OnAnyQualifiedFailureCondition 5

Automatic failover is triggered when any condition level of lower value is satisfied or when a qualifying failure condition occurs.

OnCriticalServerErrors OnCriticalServerErrors OnCriticalServerErrors 3

Automatic failover is triggered when any condition level of lower value is satisfied or when a critical server error occurs. If no setting for an Availability Group is specified, this is the default value.

OnModerateServerErrors OnModerateServerErrors OnModerateServerErrors 4

Automatic failover is triggered when any condition level of lower value is satisfied or when a moderate server error occurs.

OnServerDown OnServerDown OnServerDown 1

Automatic failover is triggered when the SQL Server service is down.

OnServerUnresponsive OnServerUnresponsive OnServerUnresponsive 2

Automatic failover is triggered when SQL Server is down or unresponsive, or when the Availability Group’s primary replica is in a failed state.

Unknown Unknown Unknown 6

The condition level is unknown.

Applies to