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

To Find out the last database restore information..

Problem:

Sometimes we need such type of information like who restore the backup of live database on test server and on which date and time?

Solution:

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
GO
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

Regards

Prince Rastogi

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

Follow me on Twitter |  Follow me on FaceBook