The Operation Status area displays a list of all backup, restore, and virtual database operations performed for the selected object for the last 7 days. To change how much status information you see, click Filter and then select a different date Range in the Event Time settings.
You can re-run any previous backup operation from this grid. To re-run a backup, right-click the appropriate operation, and then select Backup Again (executes backup using previous settings) or Backup with Different Options (opens the Backup wizard). You can also quickly restore or perform an object level recovery of backup files associated with a specific operation. Or just simply mount a virtual database.
What column information can you select?
| Column | Definition |
|---|---|
| Progress | During an operation, the progress bar will denote the percentage of the operation completed.
|
| Instance | Displays the name of the SQL Server instance that was backed up, restored, or its database was mounted by this operation. |
| Database | Displays the name of the database that was backed up, restored, or mounted by this operation. |
| Operation | Displays the type of operation performed. The types are Backup, Restore, Verify, and Virtual Database. |
| Backup Type | Displays the type of backup performed by the operation. The types are Full, Log, Differential, and File. |
| Compressed | Displays the size of the backup file after compression. |
| Ratio | Displays the ratio of the Uncompressed size of the database reported by SQL Server to the resulting Compressed size of the backup file created by SQL Safe. |
| Compression | Displays the type of compression used for the backup. |
| Database Size | Displays the size of the original database. |
| Uncompressed | Displays the size of data contained in the database, as reported by SQL Server. |
| Encryption | Displays the type of encryption SQL Safe used during the backup operation. |
| Duration | Displays the time ( hours:minutes:seconds ) required to complete the operation. |
| Start Time | Displays the start date and time of the operation. |
| End Time | Displays the end date and time of the operation. |
| Threads | Displays the number of threads SQL Safe used during the backup operation. |
| Format | Displays the backup format. SQL Safe backup (Safe) or native backup (Bak) format. |
How do you customize the columns in the grid?
Task | Action |
|---|---|
Add or remove columns in the grid | Click Filter in the pane title bar, then select the columns you want to display in the grid. |
Sort the content of a column | Click on the column header to sort the column in ascending order; click again to sort the column in descending order. |
Rearrange the order of the columns | Click on the column header and drag it to a new position in the grid. |
Group column headings | Click on the column header and drag it to a position beneath the column header by which it will be grouped. |
How do you refresh the operations status?
If a recent operation does not appear in the status view, you can refresh the status of this pane by clicking the Refresh icon in the pane title bar.
Why is the Backup/Restore/Virtual Database Operation Status grid blank?
SQL Safe only displays operation status information for Backup Agents running with an enterprise edition license. If the Backup Agent has a SQL Safe Lite or SQL Safe Freeware Edition license, this pane will be blank.
You may view the operation status for SQL Safe Lite or SQL Safe Freeware Edition Backup Agents by installing a purchased license. To use a trial before purchase, click Enable Trial License. For more information, see manage license.