Archive database

Archiving moves data from your production database to a separate archive database. You can move everything, or keep a defined number of recent days in production and move the rest.

Archiving keeps your data: unlike Clean records, which permanently deletes records, an archive stays available for auditing and reporting.

Before you start, make sure you have:

• The connection details for the destination archive database (server, instance, and credentials, depending on the provider).

• Network access to the destination database from the FileAudit service.

1. On the main screen, click the Database & audit maintenance tile. On the Database manager tab, click Archive.

2. Click the three dots (...) at the end of the Connection string field to open the Database connection window.
   

   

3. Select your archived database connector (such as SQL Server, ODBC Wizard, OLEDB Wizard, or SQLite) and click OK. A window opens for you to enter the connection details for that connector.
   

   

4. Fill in the connection details and confirm.

5. Back in the Archiving the database dialog, set the Number of days to keep in the production database. Enter 0 to archive the entire production database.

6. Click Next.

7. Click Archive.

The Scheduling panel in Database manager runs archiving automatically on a recurring basis.

1. In the Operation field, select Archive all events to archive everything, or Archive events older than and set the number of days to keep in production.

2. Set Schedule task to the frequency you want.

3. Set the Start time.

4. Select the Days of week to run the task.

To schedule record cleaning instead of archiving, see Clean records.

As soon as you archive a database, whether from Database manager or through the scheduler, it appears in the list of archived databases available in report filters.

You can run reports on your older databases without moving them back to production:

1. Open the report you want.

2. Click Filters.

3. Select the archived database from the Database list.

4. Click Apply, then refresh the report.

To work with a database created outside FileAudit, add it manually from Settings > Database so it appears in the list:

1. Open Settings, then the Database tab.

2. In the Archives section, click Add.

3. Select the database connector and enter the connection details for the archive.

4. Click Save.