How to check MSSQL Backups
Most recent backup for each database Detailed list of backups Databases Missing a Data Back-Up Within Past 24 Hours
backup
Backup Report from Enterprise Manager
How do we report on databases that haven’t been backed up? We create a report from Enterprise manager and see what has failed and what backups are potentially missing Run this in Enterprise Manager /* mark young 23-August 2011 */ SELECT a.HOST_NAME, a.DISPLAY_NAME, CASE WHEN b.end_time < SYSDATE – 2 THEN ‘3. BACKUP OLDER THAN … Read more