When you archive your registered SQL Server instances, IDERA SQL Compliance Manager moves audited events from the Repository databases to an archive database. You can archive event data for all registered SQL Server instances or a particular SQL Server instance.
You can archive events using the Management Console or the CLI. Note that SQL Compliance Manager does not automatically shrink the Repository databases after an archive is performed. After each archive operation, re-index and shrink the corresponding event databases in the Repository so that SQL Server can reclaim the space that was allocated due to the previous growth.