SQL Server finds a database without a backup from a given date
Below is a sample SQL query that retrieves the list of databases that have not had a backup since a specific date:
SELECT S.NAME AS database_name,
'No Backups' AS [Backup Age (Hours)]
FROM master.dbo.sysdatabases S
LEFT JOIN msdb.dbo.backupset B
ON S.name = B.database_name
AND B.backup_start_date > '20201101'
WHERE B.database_name IS NULL
AND S.name <> 'tempdb'
ORDER BY B.database_name;
Additional Resources:
