Creating a batch file for database backups

This topic describes how to create a batch file for database backups.

To create a script for database backups

Open the NetBackup MS SQL Client.
Select File > Backup SQL Server objects.
In the Backup Microsoft SQL Server Objects dialog box, in the left pane, expand the database instance.
In the right pane, select the R/3 database.
From the Type of Backup list, select the type of backup you want to perform, Full or Full differential.
Under Backup Script, select Save.
Click Backup.
Specify a file name and 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.