Grooming is the process of deleting audit snapshots from the SQL Secure Repository. Grooming allows you to keep only the permissions data you need for future reporting. SQL Secure allows you to schedule snapshot grooming at the enterprise and at the individual SQL Server instance levels. Keep in mind that baseline snapshots and snapshots associated with saved assessments cannot be groomed.
Grooming should be scheduled for off-peak hours so that it does not interfere with your normal business operation.
To keep a snapshot, mark it as a baseline. For more information, see Designate a baseline snapshot.
You can configure the enterprise level grooming schedule on the Grooming schedule window. In addition to routine snapshot grooming, the grooming process deletes all the snapshots that are associated with any SQL Server instances you have removed from the SQL Secure Console. To open the Grooming Schedule window, select Snapshots > Grooming Schedule from the toolbar.
To schedule grooming at the enterprise level:
- Select Snapshots > Grooming Schedule from the toolbar.
- Click Change.
- Edit the schedule.
- Click OK to save.
Set a grooming schedule at the SQL server instance level
Snapshot retention is the number of days SQL Secure will continue to store all your non-baseline audit snapshots in the SQL Secure Repository.
To schedule grooming at the SQL Server instance level:
- Right-click the SQL Server instance in the Explore Permissions tree you want to configure and select Properties.
- Select the Schedule tab.
- Click Change. The Job Schedule window opens.
- Select the frequency of your grooming job.
- Click OK to save changes.