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