SQL Server Find the database restore history

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

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)