Mahmoud ElMansy: knowledge meant to be free

3 Aug 2012

by ElMansy

No Comments

Performance, SQL Query, SQL Scripts, SQL Server, tips & tricks

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;