Other applications of NetBackup for SQL Server Performing backups and restores in an SAP environment
To create a script for transaction log backups
Before starting a transaction log backup, the database administrator should set the Transaction log backup options database option to off. This is an option on the SQL Server interface that 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 in order to ensure success in restoring your database.
Choose File > Backup SQL Server objects.
In the Backup Microsoft SQL Server Objects dialog box, select the R/3 in the Database drop-down list.
For the Type of Backup, select transaction log.
See “Backup options” on page 65 for a description of the available backup options.
5 6 7
Click OK. When prompted to start the backup, click Yes.
Check that each backup operation completed successfully by choosing File > View status.
See “Monitoring backups” on page 153 for more information.
Scheduled backups should be checked regularly to ensure they were completed successfully.
Always check that:
The most recent backup has run successfully. See “Progress reports created for NetBackup for SQL Server on the client” on page 175.
All the backups in the backup cycle are being executed according to the schedule. Gaps in a backup sequence can have serious consequences in a subsequent attempt to restore the database.
Restoring the R/3 database
This topic describes how to restore the R/3 database.
If you have scheduled differential backups, review the information in next
section “Including differential backups in a restore operation.”