Find out date and time of the last database restore

Sometimes you may have the need to find out the date and time a particular database was last restored. Here is a simple way to do it. It should work in both SQL Server 2000 and SQL Server 2005:

use msdb
select max(restore_date) from restorehistory where destination_database_name = ‘MyDatabaseName’

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.