Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Operation Details grid displays a listing of all backup and restore operations performed for the databases included in the selected policy for the last 7 days. This grid includes the following columns:

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
 If an operation completed with errors, this column will display a red bar labeled ErrorIf 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
name
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
name
that was backed up or restored by this operation.
OperationDisplays the type of operation performed. The
options
types are Backup, Restore, and Verify.
Backup TypeDisplays the type of the backup performed by the operation. The
options
types are Full,
Transaction
Log, Differential, and File.
CompressedDisplays the
compressed file
size of the backup file after compression.
RatioDisplays
the percentage of the data that was compressed
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 
the type of compression
 that was used for this backup
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
number of seconds
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.

Can you customize the columns in the Operation Details grid?

You can sort the content of any of the columns by clicking the column header.

...