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;