Archive for October, 2010

SQL SERVER DATABASE LAST RESTORED DATE


use msdb;
select
h.destination_database_name RestoredTo,
h.restore_date RestoreDate,
b.database_name RestoredFrom,
f.physical_name SourceFile,
b.backup_start_date BackupDate
from dbo.RestoreHistory h
inner join dbo.BackupSet b
on h.backup_set_id = b.backup_set_id
inner join dbo.BackupFile f
on f.backup_set_id = b.backup_set_id
order by RestoreDate desc

Tags: , , ,

Monday, October 4th, 2010 Uncategorized No Comments