Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  




           


SQL Server Query to get Latest Backup Date
SQL Server Query to get Last Backup Date for a database:

SELECT MAX(msdb.dbo.backupset.backup_finish_date) AS last_db_backup_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..backupset.type = 'D' AND database_name = 'MYNAME'
GROUP BY
msdb.dbo.backupset.database_name
ORDER BY
msdb.dbo.backupset.database_name

Created By: amos 10/19/2020 3:51:01 PM