Helpful to determine when the last database backup occurred. List all databases and the last created date of the backup.
SELECT SERVERPROPERTY(‘Servername’) AS [Server Name]
,msdb.dbo.backupset.database_name AS [Database Name]
,MAX(msdb.dbo.backupset.backup_finish_date) AS [Created Date]
FROM msdb.dbo.backupmediafamily
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE msdb.dbo.backupset.type = ‘D’
GROUP BY msdb.dbo.backupset.database_name
ORDER BY msdb.dbo.backupset.database_name
