SQL Server 2008 Recovery Mode reverts from FULL to SIMPLE
- by Eric Hazen
Three of our SQL databases have their recovery model change every night from FULL to SIMPLE. The only jobs that I'm aware of are two BackupExec jobs that run nightly. Why would the recovery model change?
Backup Jobs: SQL FULL BACKUP, SQL LOG BACKUP
Event Manager: Event 5084: Setting Database option RECOVERY to SIMPLE for database databaseName