Page tree

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?

ColumnDefinition
ProgressDuring 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.
InstanceDisplays 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.
DatabaseDisplays the name of the database that was backed up or restored by this operation.
OperationDisplays the type of operation performed. The types are Backup, Restore, and Verify.
Backup TypeDisplays the type of the backup performed by the operation. The types are Full, Log, Differential, and File.
CompressedDisplays the size of the backup file after compression.
RatioDisplays 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.
CompressionDisplays the type of compression used for the backup.
Database SizeDisplays the size of the original database.
UncompressedDisplays the size of data contained in the database, as reported by SQL Server.
EncryptionDisplays the type of encryption SQL Safe used during the backup operation.
DurationDisplays the time ( hours:minutes:seconds ) required to complete the operation.
Start TimeDisplays the start date and time of the operation.
End TimeDisplays the end date and time of the operation.
ThreadsDisplays the number of threads SQL Safe used during the backup operation.
FormatDisplays 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 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.



IDERA |  Products | Purchase | Support |  Community | Resources |  About Us | Legal