Checking all Backups with the SAPSystem

Use

Checking individual backups is not sufficient to ensure that your backup strategy is being implemented successfully. You should also periodically check all of your database backups together to make sure that your strategy is being adhered to and there are no gaps in the sequence.

In the SAP system, the Backup Restore Information transaction offers an overview of all database backups and all transaction log backups scheduled in the Planning Calendar.

Procedure

To access the backup information start the DBACOCKPIT transaction and navigate to Backup and Recovery → Backup History.
Alternatively, enter the transaction code DB12.

A result list appears showing technical details about all backups that have been executed for the last 30 days (default). Select a backup and choose History info for additional details.
If a backup failed diagnose exactly what happened. To do so, it is necessary to also look at the SQL Server error logs.