Export (0) Print
Expand All
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)

'Declaration
Public Enumeration AvailabilityGroupAutomatedBackupPreference
'Usage
Dim instance As AvailabilityGroupAutomatedBackupPreference

Member nameDescription
NoneNo preference is stated for backup on replicas based on its current role. Only BackupPriority and online/connected states will be considered for replica choice.
PrimaryBackups occur only on the primary replica, wherever it is.
SecondaryBackups occur on the secondary replicas, except when the primary replica is the only replica online.
SecondaryOnlyBackups occur only on the secondary replicas. If no secondary replicas are online, backup will not be performed.
UnknownThe desired replica to perform a backup is unknown.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft