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
 General SQL Server Forums
 New to SQL Server Administration
 recovery model changed how to track

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-08-18 : 21:39:00
Hi Experts,
for one for the production database, the recovery model someone changed for full to simple. how to track it?

it is done through client tools as per my investigation. so, there is event written, but no user name mentioned. and in errorlog, it is showing spid of the user, but by that time i checked, that is allocated to a reports user (basic). is there some way to track it?

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-19 : 09:38:42
if this is SQL 2005/08 you can create a server trigger that either disallows, or logs all ALTER DATABASE statements.

this may also be logged in the default trace, can't remember off the top of my head, but i think it is
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-08-19 : 11:19:46
IIRC Tara's Backup Routines check for situation where Recovery Model has changed (e.g. accidentally). Might be worth a look on her Blog to see how she does it (from memory I think it is the presence of a recent TLog backup but the database is in SIMPLE recovery model)
Go to Top of Page
   

- Advertisement -