SAP Backup and Restore Information (MS SQL Server)

Use

The Backup/Restore Information transaction 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. Information on jobs scheduled in both the Planning Calendar and the SQL Server Enterprise Manager is displayed.

Prerequisites

Access the backup monitor with:

CCMS ® DB Administration ®Backup logs

Alternatively, enter the transaction code DB12. In case of non-MS SQL Server system, enter transaction DB12 with the suffix MSS, for example DB12_MSS. As of SAP Release 6.40, transaction DB12 has the interface to use multi-connect to connect to remote SAP and non-SAP systems. For more information, see Monitoring Remote SQL Server Databases.

Features

On the initial screen of the monitor, CCMS Monitoring Tool – DB12 (Backup/Restore Information), you can, at a glance, get a quick overview of important information related to SAP database backups. It shows:

·        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.

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 SAP 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 and Restore Information Options

Options

Comments

Backup history

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

Restoration history

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

SQLAgent Scheduled Jobs

Displays the scheduled SQL Agent jobs for the next 30 days. The list contains job name, last run status, next run date, run schedule information etc.

SqlAgent Properties

Displays the properties set for the agent. At the operating system level, the SQLAgent is a service that is responsible for running backups that have been scheduled for a particular time. If you notice that backups are not being executed as planned, it is advisable to check the properties of the agent.

SQL Server jobs

Displays the technical details of all the jobs scheduled for the SQL Server. You can toggle between a view, which shows you All Database Jobs or CCMS jobs only which are scheduled in the Planning Calendar.
Select a job that has run and click History info to get more information about its execution.

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 a continually updated overview of all the database and log backups that are currently required to perform a database restore operation. It shows all relevant technical details such as the time of the backups, their size and volume names. The information is the basis for performing a successful backup.

See also:

Database Management Tools