Add 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. NetBackup runs the batch files in the order that the batch files appear in the backup selections list.
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.
- Select the Backup selections tab.
- Select Add.
- 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.
- Select Add to add the batch files to the backup selections list.