Date: Fri, 29 Mar 2024 12:35:07 +0000 (UTC) Message-ID: <1488792913.69997.1711715707142@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69996_467423025.1711715707139" ------=_Part_69996_467423025.1711715707139 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
You can groom audited SQL events from the event databases in the= Repository. When you groom audit data, IDERA SQL Compliance Manager delete= s all events that are older than the age (in days) you specify. You can gro= om audit data collected from all registered SQL Server instances or from se= lected instances. Grooming ensures the Repository contains only the audit d= ata you need.
If your auditing needs require long-term storage, consider implementing a maintenance plan. For more information, see Manage Audit Data.
You can groom events using the Management Console or the CLI. Note that SQL Compliance Manager = does not automatically shrink the Repository databases after a groom is per= formed. After each groom operation, re-index and shrink the affected Reposi= tory databases so that SQL Server can reclaim the space that was allocated = due to the previous growth.