knowing last backup taken dates for each database

Posted by Bandi under Sql Server category on | Points: 40 | Views : 301
Frequently, DBAs should get the backup taken dates for each database....

To monitor database health status, we suppose to check recent back up taken dates...

SELECT @@Servername AS ServerName ,
d.Name AS DatabaseName ,
MAX(b.backup_finish_date) AS LastBackupCompletedDate
FROM sys.databases d
LEFT OUTER JOIN msdb..backupset b
ON b.database_name =
AND b.[type] = 'D' -- D refers FULL Backup ; I = Differential back up, L= Log

Comments or Responses

Login to post response