AvailabilityGroupAutomatedBackupPreference Enum

Definition

This enumeration specifies how replicas in the primary role are treated in the evaluation to pick the desired replica to perform a backup.

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

Fields

Name Value Description
Primary 0

Backups occur only on the primary replica, wherever it is.

SecondaryOnly 1

Backups occur only on the secondary replicas. If no secondary replicas are online, backup will not be performed.

Secondary 2

Backups occur on the secondary replicas, except when the primary replica is the only replica online.

None 3

No preference is stated for backup on replicas based on its current role. Only BackupPriority and online/connected states will be considered for replica choice.

Unknown 4

The automated backup preference is unknown. The replica may not be able to communicate with the cluster or quorum may not be set across the Windows Server Failover Cluster.

Applies to