Viewing SQL Server Transaction Log Backup Report

If you configure a backup job or backup policy to back up Microsoft SQL Server transaction logs, you can generate a report with details about the SQL Server transaction log backup job session performed on protected computers. For more information about backup of Microsoft SQL Server transaction logs, see Microsoft SQL Server Transaction Log Settings.

To generate the SQL Server transaction log backup report, do the following:

1. Open the Home view.
2. In the inventory pane, click the Jobs node.
3. In the working area, select the necessary backup job or backup policy and click Report > SQL Server log backup on the ribbon. Alternatively, you can right-click the backup job or backup policy and select Report > SQL Server log backup.

The report contains data on the latest SQL Server transaction log backup job session:

• Cumulative session statistics: number of processed databases, details on session performance, size of backed-up data, compression ratio, backup job session status.
• Detailed statistics for every computer processed within the session: session performance, amount of read and transferred data, list of warnings and errors (if any).
• Statistics for processed SQL databases: processing duration details, number of processed databases, amount of read and transferred data, list of warnings and errors (if any).