How to archive a large database that spans over few years?
You can create an archive job that will create one archive DB per fiscal year.
If an archive job is created to archive large amounts of data over multiple calendar years, it may take a significant amount of time to finish. If you have multiple calendar years of data to archive, it is recommended to select to archive the oldest calendar year first. When the first archive job finishes, update the job settings to archive the next calendar year and so on until all the data has been archived.
Have a read through the user guide below with details on archive and purging.
https://support.quest.com/technical-documents/change-auditor/7.4/user-guide/27#TOPIC-2113389
