Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Does the event coincide with the time that Backup Exec is running jobs against your SQL Server? –  Chris W Jan 15 '10 at 17:23
    
Not that I'm aware of but that is the only job running at night that I'm aware of. –  Eric Hazen Jan 25 '10 at 22:37

1 Answer 1

up vote 0 down vote accepted

I found a job running at 3am every night with the following:
enter code here*ALTER DATABASE GBC_Reporting_3
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ('GBC_Reporting_3_log', 1);
DBCC SHRINKFILE ('GBC_Reporting_3_log' , 0, TRUNCATEONLY)
DBCC SHRINKFILE ('GBC_Reporting_3_2', 1);
DBCC SHRINKFILE ('GBC_Reporting_3_2' , 0, TRUNCATEONLY)
GO*

We had to add the following to fix the problem.
*-- Reset the database recovery model.
ALTER DATABASE GBC_Reporting_3
SET RECOVERY FULL;
GO*

share|improve this answer

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.