Listing all databases backup
By tosc
Are you sure, that you make your db backups?
CREATE VIEW ViewLastBackup
AS
SELECT a.name AS 'DataBase', Backup_Date, Days_since_last_Backup
FROM master.dbo.sysdatabases AS a LEFT JOIN
(SELECT database_name,MAX(backup_finish_date) AS Backup_Date,
ABS(DATEDIFF(day,GETDATE(),MAX(backup_finish_date))) AS Days_since_last_Backup
FROM msdb.dbo.backupset WHERE backup_finish_date <= GETDATE()
GROUP BY database_name) AS b
ON a.name = b.database_name
SELECT * FROM ViewLastBackup WHERE Backup_Date IS NOT NULL
ORDER BY 2 DESC,1
SELECT * FROM ViewLastBackup WHERE Backup_Date IS NULL
ORDER BY 2 DESC,1
You can download it here ;)
