TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

AvailabilityGroupAutomatedBackupPreference Enumeration

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

public enum AvailabilityGroupAutomatedBackupPreference

Member nameDescription
None

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.

Primary

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

Secondary

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

SecondaryOnly

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

Unknown

The desired replica to perform a backup is unknown.

Return to top
Show:
© 2016 Microsoft