Page History
...
Changes made to the recovery model used by the Repository databases should reflect your disaster recovery strategies. You may need to change the Repository recovery model to address the following situations:
- You are moving SQL compliance manager IDERA SQL Compliance Manager into a production environment and now need to implement a full recovery model
- You no longer need to back up transaction logs for the Repository databases and can use a simple recovery model
Configure the model system database before installing the Repository. For more information, see Deployment considerations. By default, the setup program installs the Repository on the Collection Server computer.
To change the Repository recovery model:
- Click Auditing on the menu bar, and then select Configure Repository Databases.
- Specify the appropriate recovery model, and then click OK. For more information, see see
.Newtablink alias Microsoft SQL Server Books Online url https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms130214(v=sql.105)
SQL Compliance Manager audits all activity on your server. Learn more > >
...