• That is a great script Karl Klingler, very compact compared to the original script, but I notice both the original script and your script does not report on the important situation for a database in full recovery mode, where there is a last database backup but never a transaction log backup.

    Can you see if you can get your script to report on this situation?

    Also you can exclude the tempdb database.

    Regards,

    DBA Pete