Re: Is there a way to tell what file a database was restored from?

Hello Michael,

Try this query:
select destination_database_name, destination_phys_name from restorehistory
inner join restorefile
on restorehistory.restore_history_id = restorefile.restore_history_id

I wrote it like that, however you can obtain other information about the restores if you "select * from restorehistory" table

--
Ekrem Önsoy



"Michael Howes" <Michael.Howes@xxxxxxxxxxx> wrote in message news:uILTrYTtIHA.1768@xxxxxxxxxxxxxxxxxxxxxxx

If I'm looking at a database in SQL Server 2005 is there a way to find out the file name of the file the person restored the database from?

thanks
mike

.