0

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

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

I found a job running at 3am every night with the following:
enter code hereALTER 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.