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

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@cdph.ca.gov> wrote in message
news:uILTrYTtIHA.1768@TK2MSFTNGP03.phx.gbl...
>
> 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