cancel
Showing results for 
Search instead for 
Did you mean: 

How to show the history of DB restore?

Former Member
0 Kudos

Hi! Gurus:

We have done a lot of db restore on a training SQLserver.

We want to know whether SQLserver keeps track those restores. That is how to show

the time when each restore happened so far?

Please help. Thanks a lot!

View Entire Topic
Former Member
0 Kudos

Hello Linda,

Try the script given in the following link:

http://www.sqldba.org/articles/31-view-database-restore-history-in-sql-server.aspx

I am sure it will help,let me know

Rohit

Former Member
0 Kudos

Very helpful!

Is there any menu path for the same purpose?

Thanks!

Former Member
0 Kudos

Menu path for?

I didnt get this?

Rohit

Former Member
0 Kudos

Right click your database -> Reports -> Standard Reports-> Backup und Restore Events (expand the categories)

Sven