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.
SQL Compliance Manager audits all activity on your server. Learn more > >
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal