You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

When you archive your registered SQL Server instances, 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 CM 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.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels