Thank this author by sharing:
By Bruce James,
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.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.