Database Archiving

Prepare Archive Database¶

• Create a new database user with the appropriate permissions

• Connect to the database user and run archive_schema.sql from the Archive folder in ActiveAccess installation package.

• To give access to the current ActiveAccess database user

• In the archive_grant.sql from the Archive folder in ActiveAccess installation package, replace the tags < archiveusername > with the newly created database user for archiving, < dbname > with the database owner name, and < dbuser > with the database user name that accesses the database. In a simple configuration the database user name may be the same as the database owner name.

• Run the updated archive_grant.sql with a sys/system connection.

Schedule Archiving¶

System Management > Archive Management

• Click the Edit link

• Tick the Automatic archive checkbox to enable automatic archiving

• Fill the remaining fields as appropriate

• For purging the archived data:

  • Tick the Automatic archive purge checkbox to enable automatic archiving

  • Fill the remaining fields as appropriate

• Click the Apply button.

Configure Archiving¶

System Management > Archive Management > Archive Databases > New Archive Database

• Enter the Archive Database link or Database user

• Click the Apply button.

Set Default Archive Database for Search¶

System Management > Archive Management > Archive Databases

• If you only have one archive database configured, it will automatically be set as the default for search. If you have more than one archive database configured, click the Set as default for search link for the desired archive database.

Set Default Archive Server¶

Servers > MIA Servers

• Click the Set as default archive server link for the desired MIA Server.

Check Archive/Purge History¶

System Management > Archive Management > Archive Databases

• Click the Archive database link to go to the Archive Database Details page

  A list of archive and purge history reports will appear under Archive History and Purge History tabs