Query to get last database backup dates

Posted on 19. February 2008 by admin
Here’s a simple query to find the last backup dates:

 

SELECT backup_start_date, database_name
FROM msdb.dbo.backupset AS b1
WHERE backup_start_date =
(
SELECT MAX(backup_start_date)
FROM msdb.dbo.backupset AS b2
WHERE b1.database_name = b2.database_name
AND type = 'D'
)

This entry was posted in SQL Server. Bookmark the permalink.