Databse Restore information

select h.backup_set_id,h.destination_database_name,f.physical_device_name,h.restore_date ,h.user_name,h.restore_type,h.replace,s.server_name

from msdb..restorehistory h,msdb..backupmediafamily f,msdb..backupset s

where h.backup_set_id=s.backup_set_id and s.media_set_id=f.media_set_id

and h.destination_database_name ='{Database name}'

order by h.restore_date desc