Does ChangeAuditor have the ability to clean up it's current database rather than archiving certain data?
Some customers may wish to clean up non-needed data from the current ChangeAuditor database rather than backing up this data to an Archive database.
To create a new Purge job to clean up the ChangeAuditor database:
1. Select “Purge and Archive” in the Configuration section of the Administration Task tab of the change Auditor Client.
2. Click the Plus (+) or “Add” button in the menu bar at the top of the form.
3. Enter the desired job name in the “Job Name” field
4. Set the number of days to keep in the “Process events older than” field.
5. Click Next and set the desired schedule
6. Click Finish.
7. This will purge data older than the number of days selected.
NOTE: Reclaiming the cleaned-up space in the database is not an automatic procedure, you will have to do a "Shrink" operation on SQL Server to then see an increase in the available space in the database (contact your DBA if you do not know how to do this). We recommend having a full backup of the Change Auditor database and to make sure that all coordinators are temporarily offline before executing the Shrink operation.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center