In Tools | Reports | Reports Manager | (Reports SQL Server 2005) | DBA's Reports | Backup Status, what values are required when prompted for Bind Variables?
This report will look into the system tables to find the last time each type of backup occurred and show the number of days it has been since that type of backup.
The value required in the 'Bind Variables' dialog box should be D, I, or L where:
D - Full Backup
I - Differential Backup
L - Log Backup
To view the script associated with the report:
1. <Right Click> 'Backup Status'
2. Edit Properties
This wil allow you to view a description of the report and the SQL which is sent to retrieve the information.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center