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

Compare with Current View Page History

« Previous Version 4 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 DatabaseSupported Recovery Model
SQLcomplianceRecovery model set for the model system database
SQLcompliance.ProcessingSimple
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 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