How to show the history of DB restore?

[Former Member]

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!

[Former Member · Accepted solution]

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 · Accepted solution]

Very helpful!

Is there any menu path for the same purpose?

Thanks!

[Former Member · Accepted solution]

Menu path for?

I didnt get this?

Rohit

[Former Member · Accepted solution]

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

Sven