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.
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 advanceArnavEven 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 |
 |
|
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) |
 |
|
|
|
|