Search <book_title>...

Veritas NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2021-06-07

Product(s): NetBackup (9.1)

Adding batch files to the backup selections list

The backup selections list in a database policy has a different meaning than for non-database policies. For example, in a Standard or Microsoft Windows policy, the list contains files and directories to be backed up. In a database policy, you can specify batch files to run. (For NetBackup for SQL Server, the scripts are called batch files and have the .bch extension.) Batch files describe the backup operations you want to start. You can start them by initiating manual or scheduled operations from the NetBackup server. These files reside on the client and direct the operation of NetBackup for SQL Server and SQL Server.

Add batch files if you want a policy that runs scheduled backups. All batch files that are listed in the backup selections list are run for manual backups and for automatic backup schedules. Create the schedules on the Schedules tab. NetBackup runs the batch files in the order that the batch files appear in the backup selections list.

Note:

Specify the correct batch file names in the backup selections list to prevent an error or possibly a wrong operation.

To add batch files to the backup selections list

Ensure that the batch file resides on the client.
See Registering authorized locations used by a NetBackup database script-based policy.
Open the policy you want to edit or create a new policy.
Before you can add batch files, you must do the following:
- On the Instances and Databases tab, select Clients for use with batch files.
- On the Clients tab, add one or more clients.
Click the Backup Selections tab.
Click New.
In the Add Backup Selection dialog box, specify the names of the batch files that you want to use. Specify the file name in one of the following ways:
- Click Browse. Navigate to and select the batch file, then click OK.
- In the Script box, type the full path name of a batch file on the client, then click Add.
  For example:
```
install_path\NetBackup\DbExt\Mssql\bkup.bch
```
  You must indicate the full pathname of the batch file.
Add any other batch files.
Click OK to add the batch files to the backup selections list.
Click OK.