Configuring a backup policy to protect a SQL Server availability group
You can create a backup policy to perform scheduled backups of a SQL Server availability group. By default, NetBackup performs backups on the primary replica. Alternatively, you can protect the preferred replica.
To configure a backup policy for the preferred or the primary replica of a SQL Server availability group
- Open the NetBackup Administration Console.
- Create a new policy.
- On the Attributes tab, configure the following:
Select the MS-SQL-Server policy type.
Specify a storage unit.
- Click on the Instances and Databases tab.
- Select Protect availability groups.
- Click New.
- Select the availability groups or availability databases that you want to protect.
- Add schedules.
- Click the Microsoft SQL Server tab.
- From the Availability Database Backup Preference list, choose one of the following:
Protect primary replica
Protect preferred replica
- (Optional) Make any other changes to the tuning parameters.
- Click OK to save the policy.