Choosing a different set of audit data may alter the policy findings. After you choose a new data set, IDERA SQL Secure updates the policy. Use the Refresh Audit Data option to change the audit data for your policy.

By default, SQL Secure always uses the most recent audit data available.

When to select different audit data

Consider refreshing the audit data when:

• Your environment has changed and you need to re-run the assessment against the most recent audit data
• You have responded to a high or medium risk by adjusting a security setting in your environment and thus need to validate your change
• You want to run the same policy against a point in time in the past, such as last week or last month

Use only baseline snapshots

Baseline snapshots can be used as a guide about how your SQL Server security model should be configured. By running your policy against baseline snapshots only, you can test the thoroughness of this guide.