Page History

When you archive audit data, the Collection Server moves audited events from the Repository (typically, the event database) to an archive database. SQL compliance manager SQL Compliance Manager creates an archive database for each registered SQL Server instance, according to the file naming conventions and event age limit you specify. Each archive database contains events collected from the audited databases hosted on the SQL Server instance. You can archive event data across all registered SQL Server instances or for a selected instance.

To ensure you are archiving uncompromised audit data, SQL compliance manager SQL CM allows you to check the integrity of the collected events. If the audit data fails this integrity check, SQL compliance manager SQL CM does not archive the data.

...

To ensure optimal event handling and performance, archive your audit data frequently. Monitor your Repository database consumption over the first few days of collecting audit data, so you can develop a maintenance strategy that best suits your needs. For more information, see Back up and restore archive databases. For more information on how to archive events, see Archive collected events.

...