Activity History Tab

Select the Activity History tab on the main window to view a history of backup and restore operations.

Select the SQL Server instance or database for which you want to see the activity history in the Registered SQL Servers pane.

To update the details, on the File menu, click Refresh Connection.

Display

Type shows the type of activity.

Date shows the date and time of the activity in the time zone local to the SQL Server.

Duration shows the time taken to perform the backup or restore operation. Note that this does not included the time taken for any activities done on completion, such as erasing existing files, copying backups to a network share, and sending notification emails.

Uncompressed Size shows the total amount of uncompressed data passed to SQL Backup Manager by SQL Server. This may be larger than the Data size and Log size reported in the database properties because data is passed to SQL Backup Manager in blocks of a minimum of 64 KB.

Compressed Size shows the size of the backup file(s) on disk.

Compressed By shows the percentage compression; SQL Backup Manager calculates the percentage compression of a backup by comparing the size of the SQL Backup Manager backup with the total database size. For example, if a database comprises a 10 GB data file and a 2 GB transaction log file and SQL Backup Manager generates a full backup of the database to create a backup file that is 3 GB, the compression for this backup is calculated as 75%, [1-(3/12)]x100.

Compression Level shows the compression level used for the backup.

Encrypted Displays Yes that the backup is encrypted.

Verified If you chose to verify a backup, Verified displays Yes if the backup files are not corrupted and can be read by SQL Backup Manager for restoring or Failed if any of the backup files are corrupted. If you did not verify the backup, No is displayed.

User Name displays the login used to access the SQL Server.

Interaction

By default, the activities are listed in date and time order, with the most recent first. You can change the sort order by clicking the header for the column by which you want to sort the list. Click the header again to reverse the order. You can also resize the columns as required.

To restore a backup, right-click the backup and click Restore . The Restore wizard is displayed.

To see properties for a backup or restore operation, right-click the activity in the Activity History and then click Properties, or double-click the activity.