To Find out the last database restore information..
Sometimes we need such type of information like who restore the backup of live database on test server and on which date and time?
We can find out such type of information from SQL Server Logs, But here the person who restore the database also delete the logs, then how can we identify?
Microsoft SQL Server provide msdb database to store all backup and restore information and many more tasks related to sql server agent.
MSDB contain special type of table named as [restorehistory] which store information of all the restore operation.
Select restore_date, destination_database_name, user_name from restorehistory
Where restore_date = date and time of restoration
Destination_database_name = name of destination database on which restore perform
Username = Name of user who perform the restore operation