SQL ServerRecovery Model Change Tracking

Question

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?

Thomas Stringer · Accepted Answer · 2012-04-06 19:27:37Z

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

answered Apr 6 '12 at 19:27

Thomas Stringer
14.2k22352

	Cool...thank you – ooutwire Apr 6 '12 at 19:29
	@ooutwire Glad to help. – Thomas Stringer Apr 6 '12 at 19:34

1 Answer