Clean Up the Database

Perform these steps to reduce the database file size.

LHC Secure: Only "administrators" are permitted to complete this task. Make sure all users are logged out of the LHC before proceeding (when multiple users share the database).

• LHC: Press Ctrl+S to show the System menu.

1. Select System>Audit Trail> System Audit Trail. (First, review the Audit Trail to make sure no one else is logged in, if applicable.)

Use the Start Date and End Date fields to define the date range of the records to display - click the Refresh button to execute your selection. Optionally, further filter the list by User or event Type.

• For archive purposes, you may want to create monthly records, i.e. limit the records to a calendar month, making several audit trail files, one for each month;
• For clean up purposes, you may prefer to select the oldest records for deletion.

When you have sorted the records as desired for deletion, fill the checkbox to Permanently remove the records from the audit trail and click the Archive to File link.

• Before proceeding, make sure there are no other LHC sessions running. All users except the administrator must be logged out.

4. Select System>Database Configuration.

5. Click Optimize to actually delete the records and to compress the database file.