who put DB on a diff recovery mode?

will the SQL error log give that info? if not, any where else to look for it?
LVL 6
anushahannaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
derekkrommConnect With a Mentor Commented:
This may be written to the Windows Event Log (Application Event Log)
0
 
reb73Connect With a Mentor Commented:
AFAIK, you will have to create CDC (Change Data Capture) to start auditing such changes.

This is a good article to review (the author is a well respected expert here - chapmandew, he may have an article here too!)

http://www.techrepublic.com/blog/datacenter/introduction-to-change-data-capture-in-sql-server-2008/520
0
 
anushahannaAuthor Commented:
derekkromm, i am trying to look for it.. any reference for event ids?
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
anushahannaAuthor Commented:
reb73, at this point CDC was not set up; for looking for who put diff recovery mode a few days ago- any other options?
0
 
mordiConnect With a Mentor Commented:
Hi,
I tested it doing a change on a database from full to simple option and the event was written to the Windows Event Log (Application Event Log) including the username, eventid  and the timestap etc...
0
 
derekkrommCommented:
Sorry for the delay. Got caught up at work.

It should be Event ID 5084

0
 
mordiConnect With a Mentor Commented:
Yes,  it is Event ID 5084.
0
 
anushahannaAuthor Commented:
Thanks very much.
0
All Courses

From novice to tech pro — start learning today.