Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Are SQL Server recovery model changes logged anywhere...WMI, error logs...etc?

For instance, if I change from FULL to SIMPLE, is this recorded anywhere?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

It is recorded in the SQL Server Error Log.

exec xp_readerrorlog 0, 1, N'setting database option recovery'

The result of that should have Text of:

Setting database option RECOVERY to FULL for database 'YourDatabaseName'.

share|improve this answer
    
Cool...thank you –  ooutwire Apr 6 '12 at 19:29
    
@ooutwire Glad to help. –  Thomas Stringer Apr 6 '12 at 19:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.