Versions Compared

Key

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

...

What column information can you select?

ColumnDefinition
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 is completed with errors, this column will display a red bar labeled Error.
 
  • If an operation is 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.
  • Operations performed to offline databases are skipped and shown as it.
InstanceDisplays the name of the SQL Server instance that was backed up, restored, or its database was mounted by this operation.
DatabaseDisplays the name of the database that was backed up, restored, or mounted by this operation.
OperationDisplays the type of operation performed. The types are Backup, Restore, Verify, and Virtual Database.
Backup TypeDisplays the type of 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.

...