hi ,

whenever you restore any database ,that activity related info got stored in

restorehistory table of msdb

plz check with using this

select destination_database_name,USER_NAME,restore_date from restorehistory order by restore_date desc

if ,i m wrong plz tell me.