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 SQLsafe allow you to schedule fast, secure backups using optimized compression and encryption settings.