- Blog - http://blog.bennett-scharf.com -

Query to get last database backup dates

Posted By admin On 19. February 2008 @ 18:59 In SQL Server | No Comments

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’
)

Article printed from Blog: http://blog.bennett-scharf.com

URL to article: http://blog.bennett-scharf.com/2008/02/19/query-to-get-last-database-backup-dates/

Click here to print.