X hits on this document





153 / 200

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.

2 3

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.

Monitoring backups

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


Document info
Document views351
Page views351
Page last viewedThu Oct 27 07:58:19 UTC 2016