Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

To create batch files for the policy that protects the preferred replica

1. This procedure assumes that you already created a separate policy for each type of backup that you want to perform.

   See Configuring an automatic backup policy for the preferred or the primary replica of a SQL Server availability group.

2. Perform steps 3 to 14 in this procedure on each replica in the availability group.

   You must log on to each replica separately and create the batch files from that replica. This way the batch files have the correct settings for each node. Backups may fail if you create a batch file on one replica and copy it to the other replicas in the availability group.

3. Log on to one of the replicas in the availability group.
4. Open the NetBackup MS SQL Client.
5. Select File > Set SQL Server connection properties.
6. From the Instance drop-down list, select the instance that hosts the availability group.
7. Select File > Backup SQL Server objects.
8. 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.

9. Select the Type of Backup and any other settings.
10. In the NetBackup Policy field, enter the name of the MS-SQL Server policy that you created.
11. From the Backup script group, select Save.
12. Click Backup and open the batch file.
13. For each operation in the batch file configure one of the following options:

    • To protect the preferred replica, add the keyword PREFERREDREPLICA PREFERRED.

    • To protect the primary replica, add the keyword PREFERREDREPLICA PRIMARY.

14. Save and close the batch file.

    Note the location of the batch file. Save the batch file for each replica to the same file location. This way you only need to enter one file location for the batch file in the Backup Selections list.

15. Repeat steps 7 to 14 for any other types of backups that you want to perform. For example, full, differential, or transaction log.

    More information is available on how to create batch files.

    See About using batch files with NetBackup for SQL Server.

16. Repeat the steps in this procedure (steps 3 to 15) to create batch files for the other availability group replicas.
17. When you have created batch files for all the replicas on which you want backups to occur, add the batch files to the policies that you created previously.

    See Adding the batch files to the policy that protects the preferred or the primary replica.