How to find database restore history from MSDB?

You can use the below query to get the particular database restore history. 

  



SELECT TOP 10 *

FROM restorehistory WITH (nolock)WHERE (destination_database_name = 'Database Name')ORDER BY restore_date DESC

All Databases

SELECT TOP 10 * FROM restorehistory WITH (nolock)ORDER BY restore_date DESC