Find the date the database was last restored

I have MS SQL Server 2005.  Is it possible to find out the date that the database was last restored?
saturationAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
select * from msdb..restorehistory
0
 
chapmandewCommented:
select distinct physical_device_name,  * from backupfile bf
join backupset bs on bf.backup_set_id = bs.backup_set_id
join backupmediafamily bm on bs.media_set_id = bm.media_set_id
where database_name = 'yourdbname'
order by backup_finish_date desc
0
 
chapmandewCommented:
sorry...misread.  Look at the create_date in this query:

select * from sys.databases
0
 
saturationAuthor Commented:
That shows the created date, but is there a date for the last time a DB was restored into that database?
0
 
saturationAuthor Commented:
Perfect!
0
All Courses

From novice to tech pro — start learning today.