Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

AvailabilityGroupAutomatedBackupPreference Enumeration

SQL Server 2012

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
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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.