Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 When this DB was restored?

Author  Topic 

CanadaDBA

583 Posts

Posted - 2004-11-17 : 11:12:29
How can I found the last time that a database was restored?

Canada DBA

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-11-17 : 11:47:49
Look in the restorehistory table in the msdb database.
Go to Top of Page

CanadaDBA

583 Posts

Posted - 2004-11-17 : 13:42:38
Thanks. It helped a lot.
quote:
Originally posted by robvolk

Look in the restorehistory table in the msdb database.



Canada DBA
Go to Top of Page
   

- Advertisement -