Find Restore History

This SQL script fetches information about database restores from a table called restorehistory in the msdb database.

info

Before running the script please fill out the variables

• {DATABASE NAME}

SELECT [user_name], 
       [restore_date],
       [destination_database_name]
FROM [msdb]..[restorehistory]
WHERE [destination_database_name] = '{DATABASE NAME}'

note

You can read more about this command in the Microsoft Documentation