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 2005 Forums
 .NET Inside SQL Server (2005)
 How to tell when the last restore occurred?

Author  Topic 

toddhd
Yak Posting Veteran

55 Posts

Posted - 2008-04-12 : 20:17:07
I'm not sure this option even exists, but I hope it does. Is there a way to query SQL Server in order to find out when the last time a database was restored (Date/Time)?

If this can be done from C#, great, but I'll take whatever info you can offer.

-Todd Davis

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-12 : 20:42:32
Query msdb..restorehistory.
Go to Top of Page

toddhd
Yak Posting Veteran

55 Posts

Posted - 2008-04-13 : 01:48:47
Thanks. That led me to this solution: http://www.sqlservercentral.com/scripts/Miscellaneous/30262/

-Todd Davis
Go to Top of Page
   

- Advertisement -