SQL Server 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
SELECT restore_date ,destination_database_name
FROM msdb..RestoreHistory
ORDER BY restore_date DESC
Output:
restore_date destination_database_name
----------------------- ---------------------------------------
2014-10-08 20:29:27.730 DatabaseForLogBackups
2014-10-08 20:29:27.560 DatabaseForLogBackups
2014-10-08 20:29:25.810 DatabaseForLogBackups
2014-04-27 17:49:14.480 AdventureWorks2008
(4 row(s) affected)