The Backup/Restore Operation Status area displays a listing of all backup and restore 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 the backup files associated with a specific operation.
What column information can you select?
| Column | Definition |
|---|---|
| Progress | During an operation, the progress bar will denote the percentage of the operation completed. When the operation is complete, it will display a green bar labeled 100%. If an operation completed with errors, this column will display a red bar labeled Error. If an operation completed with warnings, this column will display a yellow bar labeled 100% with an asterisk. This column also indicates when the backup file has been deleted (groomed), and therefore is no longer available to be restored. |
| Instance | Displays the name of the SQL Server instance that was backed up or restored by this operation. |
Icon (Enhanced Restorability) | Displays an icon if the backup includes maps containing metadata for InstantRestore and SQL virtual database. For more information about InstantRestore, see How InstantRestore works. For information about SQL virtual database, see recover objects using SQL virtual database. |
| Database | Displays the name of the database that was backed up or restored by this operation. |
| Operation | Displays the type of operation performed. The types are Backup, Restore, and Verify. |
| Backup Type | Displays the type of the 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. |
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 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.