Symptoms

We want to reduce the Form.AuditLogArchive table in the K2 database. We are using SQL Express DBs and there is a 10GB limit on the DB, which we reached now. And the Form.AuditLogArchive table is the biggest in the DB and because of that, we would like to reduce the size of the table.
 

Diagnoses

You can set the size of the  audit archive tables as per the following documentation.

https://help.nintex.com/en-us/k2five/devref/current/default.htm#dbref/auditlog-archive.html 

Resolution
The Form.AuditLog and Form.AuditLogArchive table size limits are determined in the Form.Configuration table. The default values are laid out in the help docs.

The default time interval to check the AuditLog tables is 60 minutes which is flagged in the SourceCode.Forms.Runtime.config file which is located in the Host ServerBin folder. If the AuditLog table reaches its max size the oldest entries are moved from the AuditLog table to the AuditLogArchive table in a batch which is also configured in the Form.Configuration table.

The Form.AuditLogArchive table also has a maximum size in which entries are deleted from the table once the size is met. The logic is the same in which oldest entries will be removed first.