R/3 Backup Monitor (MS SQL Server) 

Use

The Backup Monitor is an important source of information for the database administrator. It collects and summarizes information related to backups, database restore operations and tasks scheduled in the Planning Calendar. It is particularly useful for monitoring the backup strategy that has been implemented in a system.

Prerequisites

Access the backup monitor with:

Administration ® CCMS ® DB Administration ® Backup logs

Alternatively, enter the transaction code DB12.

Features

On the initial screen of the monitor you can, at a glance, get a quick overview of important information related to backups. It shows the last successful backups for the R/3, master and msdb databases and R/3 transaction logs. It also indicates the amount of log space allocated and how much is still free.

When you look at the amount of free space specified for logs, keep in mind that the data displayed reflects snapshots taken at a specific point in time. As logs are backed up and truncated at hourly intervals, a large amount of free space might be displayed because the log has just been truncated. For more information see Monitoring the R/3 Log Disk.

Further functions available enable you to access technical details about past backups, restore operations and other actions planned in the DBA calendar:

Backup Monitor Options

Backup history

Displays technical details about backups that have been executed. The date and time of execution, size of the backup and the name of the physical device the dump was written to are displayed. The pushbuttons in the menu let you choose different views. For example Logs Backups only displays the log backups.

Restoration history

Gives an overview of all the restore operations performed in the system. Full technical details are specified, including the size and type of dump restored, the date when the dump was created, the name of the device and volume used.

SQLAgent Properties

Technical data about the Agent

Backup device list

Lists the backup devices available in the system. It shows whether the devices are disks or tapes, gives their logical names and their corresponding physical location.

Tapes needed for restore

Gives an overview of all the backups that are available for a restore operation together with all relevant technical details such as the time of the backup, the size, the tape label and so on.

SQL Server jobs

Displays technical details of all the jobs scheduled for the SQL Server. Options in the menu allow you to focus on a subset of jobs, for example, the CCMS jobs.

 

See also:

Database Management Tools