You can test your audit settings whenever you apply a change. Testing helps ensure you collect the audit data you need to maintain continuous compliance with internal and external standards.

To test your audit settings:

  1. Navigate to Registered SQL Servers in the Administration tree.
  2. Select the SQL Server instance on which you want to test your audit settings.
  3. Ensure the SQLcompliance Agent for the target SQL Server instance is using your most recent audit settings.
  4. On the Auditing menu, click Collect Audit Data. This action will collect SQL Server events based on your current auditing settings.

 

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