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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

Your Answer


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.