Getting last backup date for Ola Hallegren SQL Maintenance Solution

As already mentioned in this post, Ola ‘s solution to backup your SQL Server databases is recognized as a easy-to-deploy, no stress, solution. You can easily build on top of it.

Without installing any SQL cmdlet nor looking in the table the scripts produce, here is a solution to get  the latest backups for each database solely based on the files’ timestamps.

The usage is simple:

More elaborated use is to create a report to group the databases by their last backup day


Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.