QMB interface > Server and policy menu > Database page |
When a database is selected in the list, its details will be shown in the right part of the window.
Database information page |
The header of the page contains the following commands:
Backup database – opens the full database backup creation form.
Restore from backup - opens the database restoration form.
Refresh– updates the information on the form.
Database information
Status – database status (online, offline, restoring and others. More info https://msdn.microsoft.com/en-us/library/ms190442.aspx)
Recovery model – the database recovery model.
Last full backup – date and time of the last full backup. The information is read from the msdb system database.
Last bakup of the transaction log - date and time of the last log backup. The information is read from the msdb system database.
File size
This section contains a chart which shows how the database size has changed with time. The data size, the reserved data size and the full size of the transaction log are shown in color.
By clicking the button the database files size will be shown in a table. Each column shows used and reserved size.
The SQL server reserves free disk space in files for future data growth. |
The lower part of the section shows the average increase for a day, week and month.
Database size statistics are collected for SQL servers with a commercial version of QMB. Database sizes are updated by schedule 4 times a day: at 7 AM, 1 PM, 5 PM and 8 PM.
When calculating the average daily increment, the program uses the raw size of data without reserved space. The average increment can be a negative value (after data deletion). |
Maintenance log
The maintenance log contains the results produced by the execution of database tasks. Results can be filtered by task execution date using the filter above the list.
If you want to filter by Task or Status, click the button in the header of the corresponding column and select the necessary value.
Double-clicking on a log file record will open a form with detailed information about the corresponding task: start and finish time, duration and script messages.