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