Archiving takes too long.
ApexSQL Audit logs show:
ERROR [GUI ]: Archiving process is in progress -
After archiving takes place or is manually cancelled, servers, reports and other configurations are missing.This issue is caused by accumulated ApexSQL Alerts.
During the archiving process the active repository database (ApexSQLCrd) is renamed as ArchiveCrd+Timestamp, e.g.
Then, a new ApexSQLCrd database is created. Further, configuration data is copied from the recently renamed ApexSQLCrd database (ArchiveCrd+Timestamp) to the new ApexSQLCrd. Alerts are also copied during this process. The amount of data to be copied, either in the form of large quantities of text data or a large number of alerts, is directly proportional to the time it takes to complete the archiving process.
The missing configuration is stored in every Archive database, it can be recovered with the following process:
The archiving process was upgraded with ApexSQL Audit version 2021, therefore resolving this issue. Upgrade to latest ApexSQL Audit release is highly recommended.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center