To create a batch file for transaction log backups

1. Before starting a transaction log backup, the database administrator should set the Transaction log backup options database option to off. This option on the SQL Server interface applies to the databases.

   The entire sequence of transaction logs generated following any database dump must be maintained on the same NetBackup server. NetBackup for SQL Server requires that you follow these guidelines in devising your backup strategy to ensure success in restoring your database.

2. Select File > Backup SQL Server objects.

3. In the Backup Microsoft SQL Server Objects dialog box, in the left pane, expand the database instance.

4. In the right pane, select the R/3 database.

5. For the Type of Backup, select transaction log.

6. Under Backup Script, select Save.

7. Click Backup.

8. 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.

9. Click Yes to open and edit the batch file.