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)
 anybody knows which logs saves this

Author  Topic 

techy
Starting Member

2 Posts

Posted - 2005-08-23 : 10:28:24
Hi All,

I have set recovery model to simple and next day observer all db recovery model to full.

Does anybody know where it stores the information that will tell me who and when the recovery model was changed.

mr_mist
Grunnio

1870 Posts

Posted - 2005-08-23 : 10:31:03
This information would not normally be recorded.

Only db owners or server admins would be able to do that, what sort of security do you have?

-------
Moo. :)
Go to Top of Page
   

- Advertisement -