Condividi tramite

AvailabilityDatabaseSynchronizationState Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.SqlEnum.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

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
Enum
AvailabilityDatabaseSynchronizationState
Attributes
TypeConverterAttribute

Fields

Name Value Description
NotSynchronizing 0

The primary is not pushing data to the secondary.
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.
Synchronized 2

The database replica is synchronized with the primary.
Reverting 3

The database replica is reverting after a failover.
Initializing 4

The database replica is initializing after a failover.

Applies to