A disaster recovery strategy allows you to plan for unexpected outages to ensure you can continue auditing SQL Server activity and policy compliance.
When you implement IDERA SQL Compliance Manager in your production SQL Server environment, consider preparing a disaster recovery strategy to minimize audit data loss should the Collection Server become unavailable. Use the following procedures and guidelines to implement a new disaster recovery strategy or modify an existing disaster recovery strategy.
The frequency at which you back up the Repository databases depends on the following factors:
The backup frequency should reflect your maintenance needs and allow you to meet future compliance requirements.
After you identify the appropriate backup frequency for your compliance needs, use a tool such as Idera SQL Safe to schedule routine backups of the Repository databases.