Date: Fri, 29 Mar 2024 05:01:09 +0000 (UTC) Message-ID: <1429418889.69611.1711688469922@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69610_1821038525.1711688469914" ------=_Part_69610_1821038525.1711688469914 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 Mana= ger does not automatically shrink the Repository databases after a groom is= performed. After each groom operation, re-index and shrink the affected Re= pository databases so that SQL Server can reclaim the space that was alloca= ted due to the previous growth.