Checking Individual Backups with the SAPSystem

Use

You can check whether your most recent database and transaction log backups are usable in the 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.

Procedure

To access the DBA Planning Calendar in the SAP system, go to the DBA Cockpit and choose Jobs → DBA Planning Calendar.
The Calendar is displayed on the screen.
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 part shows general information about the task. The lower part 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 Windows Application Event Log. In the Windows log, search for SQL Server and SQL Server Agent entries.