Use the Server Selection tab to select the Database Availability Group (DAG) servers.
Server Selection
-
Automatic Selection
When this option is selected, all the available DAG servers are selected automatically. In the DAG Options area, you can define the backup conditions that are available.
-
Manual Selection
When this option is selected, you can assign any server that is available within the DAG to each database individually.
-
Discover
When Manual Selection is selected, click this button to discover which servers are available. The servers appear in the Server Associations list.
DAG Options
-
Backup from Passive Copy
When this option is selected, backups run on the first available passive server. This option is selected by default.
-
Backup from Active Copy if No Passive Copy is Available
When this option is selected, backups run on the active server if no passive server is available.
-
Use Last Activation Preference to Select Passive Copy
When this option is selected, backups run on a server with the highest activation number. This ensures the backup runs on a server that is least likely to become active in a failover case.
Note
If Automatic selection is selected, but all the DAG options are cleared, the backups run on the active server. In this case, backups run on the passive server only when no active server is available.
Server Associations
This field lists the names of the servers that were found during discovery.