LinkedIn | FaceBook | Twitter
If you kick off a backup or restore operation, this report will track the event and also provide information like the size and location for the operations. Note that this reports is per database, so each database will have its own event history. If the database has both backup and restore opertions performed on it, they will both be in the same report.
A very useful feature in this report is that you will get an average on the Backup time for the database. This is important so that you can plan your maintenance windows. Here are the additional columns you’ll get in this report.
The first band shows the Average Time Taken For Backup Operations:
The second band shows the Average Successful Backup Operations:
The third band shows the Backup Operation Errors. Note that some of this information requires the default trace to be running:
The final band shows the Successful Restore Operations:
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re