AvailabilityDatabaseSynchronizationState Enum

Definition

The different synchronization states a database participating in an HADR Availability Group can be in.

[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.AvailabilityDatabaseSynchronizationStateConverter))]
public enum AvailabilityDatabaseSynchronizationState
[<System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.AvailabilityDatabaseSynchronizationStateConverter))>]
type AvailabilityDatabaseSynchronizationState = 
Public Enum AvailabilityDatabaseSynchronizationState
Inheritance
AvailabilityDatabaseSynchronizationState
Attributes

Fields

Initializing 4

The database replica is initializing after a failover.

NotSynchronizing 0

The primary is not pushing data to the secondary.

Reverting 3

The database replica is reverting after a failover.

Synchronized 2

The database replica is synchronized with the primary.

Synchronizing 1

Data movement is happening between the primary and the secondary. This will be the state even if there is currently no data to be sent between the two.

Applies to