Configuring an automatic backup policy for preferred replica of a SQL Server availability group (legacy SQL Server policies)
This topic describes how to create a backup policy for automatic (scheduled) backups of the preferred replica in a SQL Server availability group (AG). Create a policy for each type of backup that you want to perform. For example:
Policy A | Schedules: Full backup, run weekly Backup Selections: Batch file for full backups Clients: Node A, Node B, Node C |
Policy B | Schedules: Full backup, run daily Backup Selections: Batch file for full differential backups Clients: Node A, Node B, Node C |
Policy C | Schedules: Full backup, run per your RTO and RPO Backup Selections: Batch file for transaction log backups Clients: Node A, Node B, Node C |
To configure an automatic backup policy for the preferred replica of a SQL Server availability group
- Log on to the master server as administrator (Windows) or root (UNIX).
- Open the NetBackup Administration Console.
- If your site has more than one master server, choose the one on which you want to add the policy.
- Select Actions > New > Policy.
- In the Add a New Policy dialog box, in the Policy name box, type a unique name for the new policy.
- Click OK.
- On the Attributes tab, configure the following:
Select the MS-SQL-Server policy type.
Specify a storage unit.
- On the Instances and Databases tab, select Clients for use with batch files.
The tab name changes to Clients and the Backup Selections tab now lets you specify and browse for scripts.
- On the Schedules tab, add a Full Backup schedule.
NetBackup also creates a Default-Application-Backup schedule. Use this schedule to set the retention level for the policy. See the NetBackup Administrator's Guide for more information.
- On the Clients tab, add the name of each node in the availability group.
Use the NetBackup client name for each node. If a replica is hosted on a failover cluster instance (FCI), use the virtual cluster instance name.
- Click OK to save the policy.
- Repeat step 4 to 11 in this procedure to create a policy for each type of backup (full, full differential, transaction log) that you want to perform.
Each type of backup requires a separate policy.
- On each node in the AG, create a batch file for each type of backup that you want to perform with each policy.
See Creating batch files for the policy that protects the preferred replica.