Backup Verification

The following script runs against the current server and retrieves number of days since last full or differential and the number of days between them. it also retrieves the number of hours since the last transaction log backup.It currently returns a grid output.currently the script is under going changes to send XML back to an email that SQL monitors and will be inserted into a dashboard type webpage.By setting parameters for how long it should be between each type of backup tracked the dashboard turns the server red if the threshold is missed.