Saturday, 16 February 2013

Find which db have not been backuped

This is a script I run periodically to identify databases with no backup.
I’ve been running this just in case a database is created out of left field or maybe was omitted from a backup job.

use msdb
select distinct
from sys.databases d
left join backupset bs
on bs.database_name =
where bs.database_name is null
and <> 'tempdb'
order by

No comments:

Post a Comment