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
 SQL Server Administration (2005)
 Know how many times the database got restored?

Author  Topic 

kgotnet
Starting Member

1 Post

Posted - 2008-12-05 : 02:21:06
Guys,

Is there a way to know how many times a database got restored?

Any links pointers helps ideas, highly appreciated.

KG.

Carat
Yak Posting Veteran

92 Posts

Posted - 2008-12-05 : 05:04:33
You can look in the table "restorehistory" in the Msdb database.
Every time a database is restored it is logged in this table.
Go to Top of Page
   

- Advertisement -