Find the database restore history

When ever you restored database from the backup file the sql server stored information on msdb database table restorehistory.

SELECT restore_date ,destination_database_name
FROM msdb..RestoreHistory
ORDER BY restore_date DESC