get SQL Server Database Restore Dates

Technorati Tags: sql server

use msdb
select
    DBRestored = destination_database_name,
    RestoreDate = restore_date,
    SourceDB = b.database_name,
    SourceFile = physical_name,
    BackupDate = backup_start_date
from RestoreHistory h join BackupSet b
    on h.backup_set_id = b.backup_set_id
        join BackupFile f
    on f.backup_set_id = b.backup_set_id
order by RestoreDate

Technorati Tags: sql server