Transaction code DB12 is to collects and presents information that is necessary to monitor database backups. It is an important source of information for the database administrator who has the task of supervising the execution of a defined backup strategy.
On the initial screen of the monitor, it shows overview of important information related to SAP database backups.
• The last successful backups for the SAP, master and msdb databases and transaction logs.
• The last SAP database size and duration of the backup job.
• Whether the SQL Server Agent is started or not.
• The amount of log space allocated and how much is still free.
• The Recovery interval, which specifies the maximum time that SQL Server should spend recovering after a database startup.
1. Overview of database backups -> Database Backup Logs Screen
2. You can also check for the Redo log backups. In there, you can find the Archiving directory status, Overview of redo log files and the Overview of the redo log backups
Note
Check the last date backups & remark the start/end time & verify that the backup is completed successfully or not.
