Maintaining the Repository databases helps you achieve optimal performance and ensure long-term audit data integrity. Repository database maintenance includes backup and restore operations, and should coincide with your established disaster recovery strategies.
Before you implement a disaster recovery strategy for the Repository databases, review the following supported recovery model settings.
| Repository Database | Supported Recovery Model |
|---|---|
SQLcompliance | Recovery model set for the model system database |
SQLcompliance.Processing | Simple |
SQLcompliance_Instance | Simple, or recovery model set for the model system database |
SQLcmArchive_instance_Time_Partition | Simple, or recovery model set for the model system database |
You can perform backups on a routine basis as a scheduled job or manually on an as-needed basis. Refer to your established disaster recovery strategies when implementing a backup or restore policy for the Repository databases. Tools such as IDERA SQL Safe allow you to schedule fast, secure backups using optimized compression and encryption settings.