SQL 2008 Change recovery model resetting from Simple to Full

sql-server-2008

One of our SQL databases recovery model keeps resetting from Simple to Full causing the log file to fill up.

The only thing we could think of was that IT had been restoring that database. Would this default the recovery setting to Full?

Best Answer

Restoring a database will set its recovery mode to the same as the source database was when it was backed up; there is no default, it is an attribute of the database stored in the backup and retained when it is restored. If you want simple mode, you'd have to change it after the restore is complete.