This is a script I run periodically to identify databases with no backup. I started running this because I once encountered a remote application that was creating databases which, caused a failure in a log backup job. So I’ve been running this ever since just in case a database is created out of left field or maybe was omitted from a backup job.
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,636 reads
