Today, I am going to share few very useful scripts which will report us on Database Backup from different view points.
To get the List/History/Log of all the Successful Backups
To get a list of all successful Backups taken till date for a particular Database
To get the List of all Databases which are not backed up till date
To get the List of all Databases which are not backed up since last X days
To get a list of the Latest successful backups of all Databases
To get the Latest successful backup of a particular Database
To get a list of Databases that were backed-up and do not currently exist
Hope, the above given script will be of help to you. Also, I would like to request you to please add any relevant script which you feel would be useful as a comment.