Are SQL Server recovery model changes logged anywhere...WMI, error logs...etc?
For instance, if I change from
SIMPLE, is this recorded anywhere?
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 only takes a minute to sign up.Sign up to join this community
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
Setting database option RECOVERY to FULL for database 'YourDatabaseName'.