Checking Individual Backups with R/3 

Use

You can check whether your most recent database and transaction log backups are usable in the R/3 Planning Calendar. It is best to check the backup tape immediately after the backup has finished, before you remove the tape.

You should at least check whether the transaction log backups are completed successfully on a daily basis. Omitting such a check could have serious consequences. In the event of a hardware crash and a subsequent restore operation, this may result in the loss of several hours of data.

See also:

Checking all Backups with R/3

Procedure

  1. To access the Planning Calendar in R/3, choose Administration ® CCMS ® DB Administration ® DBA Planning Calendar.

    2. Alternatively enter the transaction code DB13.

    The Planning Calendar is displayed on the screen.

  2. Double-click on the scheduled backup task whose history you want to display. A backup that has failed is indicated in red.

A window with information about the task opens.
The upper half shows general information about the task. The lower half shows whether the task was successful and any messages that were generated.

If the backup failed you can sometimes find additional information in the SQL Server Error Log, the SQL Agent Error Log or the NT Application Event Log. In the NT log search for SQL Server and SQL Server Agent entries.

See also:

Viewing the Error Log with R/3

R/3 Planning Calendar