Backup History
You find the Backup and Recovery monitor in the DBA Cockpit when navigating to Backup and Recovery → Backup History.
This monitor displays all technical details about the backups executed on the SQL Server databases including databases backups executed by third party backup tools. The menu buttons let you choose different views. For example Logs Backups only displays the log backups. CCMS Backups only displays backups scheduled in the Planning Calendar.
The Backup and Recovery monitor displays the following information for each backup operation performed in the system:
| Field | Description |
|---|---|
|
Backup set description |
Backup set description. The SQL agent job name is used as backup set description |
|
Mediaset name |
Name of the media set |
|
Backup type description |
Type of the backup |
|
Backup start time |
Date and time backup operation started |
|
Backup finish time |
Date and time backup operation finished |
|
Backup expiration date |
Date and time the backup set expires |
|
Backup set |
Name of the backup set |
|
Backup type |
Backup type (D,I,L) |
|
Database name |
Name of the database involved in the backup operation |
|
Backup set ID |
Unique backup set identification number that identifies the backup set |
|
Backup set position |
Position of the backup set files |
|
Backup mediaset description |
Media set description. Job name is used here if it is a CCMS backup |
|
Mediaset ID |
Unique media set identification number that identifies the media set containing the backup set |
|
Backup software name |
Name of the backup software that wrote the media label |
|
First family media |
First family number of the media where the backup starts |
|
SQL task server |
Name of the SQL Server |
|
Host server name |
Name of the computer running SQL Server |
|
Job ID |
SQL Agent job ID |