Mahmoud ElMansy: knowledge meant to be free

SQL Query To Determine The Last Database Backup Date

This simple script will get list of dates of backups.


use msdb
SELECT database_creation_date,backup_start_date,backup_finish_date,
name, user_name, backup_size
FROM backupset
WHERE (database_name = N'DataBaseName')
ORDER BY backup_finish_date DESC;