Check Backups
Following statement can be used to see the last backups of all databases. You get information of last backup’s start time, end time, duration in minutes, hours since last backup both for full and log backups. SELECT db.name,db.recovery_model_desc,d.[Database Backup Start],d.[Database…
