You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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.

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels