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)
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. |