Page History
Change the following model system database properties to ensure optimal performance and complete backups of the IDERA SQL Compliance Manager Repository databases. The Repository databases store your audit settings and collected audit data. Whenever the Collection Server creates an events or archive database, SQL Server uses the model database as a template for the new database, applying the same property values.
...
| Property Name | Benefits | Value |
|---|---|---|
| Automatically grow file | Allows the tempdb database to expand as needed, accommodating cases when the collected audit data set is larger than expected | Selected |
| File growth | Allows SQL Server to efficiently handle any required file growth | 25% |
| Recovery Model | Allows you to perform full backups of the Repository database | Simple |
| Space allocated | Allows ample database space for audit data collection, so file growth occurs less frequently | 200 MB |
...
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |