I utilised sp_Blitz in one of our database server and it is basically handy as we could get a come to feel how the database is behaving. The third section from the code displays the most recent comprehensive backup, https://www.ralantech.com/sql-health-check-consulting-service/