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

1_SQL_Server_To_Find_out_the_database_restore_information..

 

Regards

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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Avatar

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. Required fields are marked *