Page History
Grooming is the process of deleting audit snapshots from the IDERA 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.
...
You can configure the enterprise level grooming schedule on the Grooming schedule window.
To schedule the grooming schedule at the enterprise
...
level:
- Select from the menu toolbar Snapshots > Grooming Schedule. The Grooming Schedule window opens. By default the grooming process occurs every Monday at 12:00 AM
- If you want to change the default grooming schedule, click Change. A Job Schedule window opens.
- Edit the schedule according to your requirements. You can specify if you want to have a Daily, Weekly, or Monthly grooming schedule and define the respective frequency settings.
- Click OK to save the schedule.
...
| Info |
|---|
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 |
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 you want to configure in the Audited SQL Servers tree of the Explore Permissions view and select Properties.
- The Audited SQL Server Properties window opens, select the Schedule tab.
- Specify the number of days between 1 and 10000 that SQL Secure will keep snapshots before grooming them.
- Click OK to save changes.
| Excerpt |
|---|
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > > |