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;