How to change the default Recovery Model Option for new SQL Databases
Article by Justin Williams updated February 26, 2020
Article
By default when a new database is created within Microsoft SQL the recovery model option is set to full. If you’re capturing daily backups, a full recovery model can cause issues with the transaction log affecting performance. We’ve previously looked at how to change the recovery model, but we can change a setting within SQL to make the default recovery model set to simple.
How to set the default recovery model to simple
- Log in to the SQL Server Management Studio using the sa (system administrator) account;
- Expand the Databases folder
- Then the System Databases folder
- Select the model DB
- Right-click > Properties;
- Select the model DB
- Then the System Databases folder
- Select Options and for Recovery Model via the drop-down, we can switch it from Full to Simple, then hit OK;
Then any new vaults we create, the database Recovery Model will be set to simple;
Related Links
Want to do more with SOLIDWORKS PDM?
Our Certified SOLIDWORKS PDM Experts can help you to: