Creating a batch file
You can use any of the backup or restore dialog boxes to create a batch file that contains a NetBackup for SQL Server script. This script can be executed at a later time from the Manage Scripts dialog box.
Or you can launch the script from the dbbackex command line program or through the NetBackup scheduler. See the example batch files.
NetBackup for SQL Server sample batch files
To create a batch file
- Select File > Backup SQL Server objects or File > Restore SQL Server objects.
- Select the object you want to back up or restore.
- Select the backup or restore options.
- In the Backup script or Restore script group, click Save.
- Click Backup or Restore.
- Specify the following folder for the batch file:
install_path\NetBackup\DbExt\MsSql\folder.Batch files must reside on the host from which they executed. If you perform actions on a remote host, the batch file must reside on that remote host.
See Registering authorized locations used by a NetBackup database script-based policy.
- Give the file a unique name with the extension .bch.
- Click Save.
Alternatively, you can select the name of an existing file and NetBackup appends the new script to it.
- Click Yes to open and edit the batch file.