Page History
This The Archive Preferences window allows you to set the age at which audited events are archived, configure how the archive databases are partitioned and named, and schedule archiving to run automatically. You can continue to report on all audited events that you archive. IDERA SQL Compliance Manager uses these settings each time you archive audited events collected for a registered SQL Server instance.
Available fields
Archive Options
...
You can also skip the integrity check SQL CM Compliance Manager usually performs before archiving your collected events. If the audit data for the selected SQL Server instance fails this integrity check, SQL CM Compliance Manager does not archive the data.
...
- How often the archive database is partitioned (by month, quarter, or year)
- Naming conventions for the archive databases
- Location where you want the archive database to reside
By default, the Collection Server creates a new archive database at midnight (GMT) when the specified time period (month, quarter, year) ends. For example, if you set archive creation to occur every month, the Collection Server creates a new archive database at midnight on the first day of each month. Each archive database represents a separate data set. You can report on audited events from each archive database.
Scroll pdf ignore | ||||||
---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Compliance Manager audits all activity on your server. Learn more > >
...