SQL Server – To Find out the database restore information..

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.

Use msdb
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





Prince Rastogi

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook


About Prince Rastogi

Prince Rastogi is working as Database Administrator at Elephant Insurance, Richmond. He is having more than 8 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor and Blogger at SQLServerGeeks.com. He is a regular speaker at DataPlatformDay events in Delhi NCR. He has also presented some in depth sessions about SQL Server in SQL Server Conferences in Bangalore.

View all posts by Prince Rastogi →

4 Comments on “SQL Server – To Find out the database restore information..”

Leave a Reply

Your email address will not be published.