Availability Group Properties: New Availability Group (Backup Preferences Page)
Published: May 17, 2016
Updated: May 17, 2016
Applies To: SQL Server 2016
Use this dialog box to view and change the backup preferences of the selected availability group.
To view availability group properties
[Use the Always On Dashboard (SQL Server Management Studio)](../Topic/Use%20the%20Always On%20Dashboard%20(SQL%20Server%20Management%20Studio).md)
Specifies that backups should occur on a secondary replica except when the primary replica is the only replica online. In that case, the backup should occur on the primary replica. This is the default option.
Specifies that backups should never be performed on the primary replica. If the primary replica is the only replica online, the backup should not occur.
Specifies that the backups should always occur on the primary replica. This option is useful if you need backup features, such as creating differential backups, that are not supported when backup is run on a secondary replica.
Specifies that you prefer that backup jobs ignore the role of the availability replicas when choosing the replica to perform backups. Note backup jobs might evaluate other factors such as backup priority of each availability replica in combination with its operational state and connected state.
This grid displays the current backup priority of each server instance that hosts a replica for the availability group. Use this grid to change the backup priority of one or more availability replicas.
The name of the instance of SQL Server that hosts the availability replica.
Backup Priority (Lowest=1, Highest=100)
Specifies your priority for performing backups on this replica relative to the other replicas in the same availability group. The value is an integer in the range of 0..100. 1 indicates the lowest priority, and 100 indicates the highest priority. If Backup Priority = 1, the availability replica would be chosen for performing backups only if no higher priority availability replicas are currently available.
Select if you never want this availability replica to be chosen for performing backups. This is useful, for example, for a remote availability replica to which you never want backups to fail over.
[Active Secondaries: Backup on Secondary Replicas (Always On Availability Groups)](../Topic/Active%20Secondaries:%20Backup%20on%20Secondary%20Replicas%20(Always On%20Availability%20Groups).md)
ALTER AVAILABILITY GROUP (Transact-SQL)