NetBackup™ for Microsoft SQL Server Administrator's Guide

To create batch files for the policy that protects a specific replica

1. This procedure assumes that you already created a policy.

   See Configure an automatic backup policy for a specific replica of a SQL Server availability group.

2. Log on to the availability replica you want to protect.
3. Open the NetBackup MS SQL Client.
4. Select File > Set SQL Server connection properties.
5. From the Instance drop-down list, select the instance that hosts the availability group.
6. Select File > Backup SQL Server objects.
7. Select the objects you want to backup in one of the following ways:

   • Select one or more databases, filegroups, or files.

   • To back up all databases, including the system databases (DATABASE $ALL), select the instance. From the Back up group, select All.

8. Select the Type of Backup and any other settings.
9. In the NetBackup Policy field, enter the name of the MS-SQL Server policy that you created.
10. From the Backup script group, select Save.
11. Click Backup and save the batch file.

    Do not use the PREFERREDREPLICA TRUE, PRIMARY, or PREFERRED keyword in your batch files. Backups are skipped if the backup policy does not include the node that hosts the preferred replica.

12. Repeat steps 6 to 11 for any other the types of backups that you want to perform. For example, full, full differential, or transaction log.

    More information is available on how to create batch files.

    See Requirements to use batch files with NetBackup for SQL Server.

13. When you have created all the batch files, add these files to the policies that you created previously.

    See Add the batch files to the policy that protects a specific replica in the availability group.