Symptom
How to Maintain Database and Log File Settings for SAP Business One to ensure the application achieves optimum performance.
Solution
General guidelines
The following options should be set for SBO-COMMON Database
- Autogrowth – 10% unrestricted
- Autoshrink – True
- Parameterization – Simple
- Recovery Model – Simple
The above options for the company database will be at the discretion of the system administrator based on the needs of each company.
Please see the Microsoft article for an overview of database recovery models that exist, this will help to decide the best option to use according to your customer’s needs.
For Microsoft SQL Server 20xx
How to set database options
- Open SQL Server Management Studio
- Select the server instance. Expand Databases.
- Right-click on <database name>
- Select Properties → Files → Autogrowth
- Select Properties → Options → Autoshrink
- Select Properties → Options → Parameterization
- Select Properties → Options → Recovery Model
How to shrink log file
Refer to SAP note 1224089 for full details on reducing the size of the database log file.