Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
'Declaration
Public Enumeration AvailabilityGroupAutomatedBackupPreference
'Usage
Dim instance As AvailabilityGroupAutomatedBackupPreference
public enum AvailabilityGroupAutomatedBackupPreference
public enum class AvailabilityGroupAutomatedBackupPreference
type AvailabilityGroupAutomatedBackupPreference
public enum AvailabilityGroupAutomatedBackupPreference
Members
| Member name | Description | |
|---|---|---|
| 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. |