It would be nice with a build in option to trigger notifications based on the date since last backup of any databse.
We are currently using this custom SQL Query i 'msdb':
SELECT STUFF((SELECT N', '+ name FROM (SELECT TOP (100) PERCENT db.name FROM (SELECT name FROM master.sys.databases WHERE (state =0) AND (NOT (name IN ('tempdb')))) AS db LEFT OUTER JOIN (SELECT database_name AS name, backup_finish_date AS timestamp FROM dbo.backupset UNION SELECT name, create_date FROM master.sys.databases) AS b ON b.name = db.name GROUP BY db.name HAVING (NOT (1* ISNULL(STR(ABS(DATEDIFF(hh, GETDATE(), MAX(b.timestamp)))),-1) BETWEEN 0 AND 48)) ORDER BY db.name) AS [n1] FOR XML PATH(''),TYPE).value('text()[1]','nvarchar(max)'),1,2,N'') AS [Missing]
It would be nice with a build in option to trigger notifications based on the date since last backup of any databse.
We are currently using this custom SQL Query i 'msdb':
// Martin.