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 DatabaseSupported Recovery Model
SQLcomplianceRecovery model set for the model system database
SQLcompliance_InstanceSimple, or recovery model set for the model system database
SQLcmArchive_instance_Time_PartitionSimple, 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.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels