6. Database

6.1 Introduction to the Database

OVERLAPS uses an SQLite database to store, query and organise much of its data. The database file can be found at the following location:

C:\ProgramData\Int64 Software Ltd\OVERLAPS\overlaps.sqlite

6.2 Editing the Database

While the database file can be modified using a variety of tools available on the internet, it relies heavily on inter-data relationships (foreign keys) and making any changes to the data could lead to unexpected or undesirable results.

Additionally, much of the data found in the database is frequently re-scanned from its source (Active Directory) and updated. So any manual edits are likely to be replaced automatically, making it much more preferential to modify the source data rather than that stored in the database.

For these reasons, we do not recommend manually editing the database. If a situation presents itself in which making manual adjustments is deemed necessary, please contact us (see Getting Support) first to see if there is a better way.

6.3 Database Backup and Restore

The OVERLAPS database is automatically backed up at 01:30 every morning (local server time). The backup file can be located at:

C:\ProgramData\Int64 Software Ltd\OVERLAPS\overlaps.backup.sqlite

In the event that you need to restore the backup, please follow this procedure.

  1. Stop the OVERLAPS service
  2. Take a copy of both the overlaps.sqlite database file and the overlaps.backup.sqlite backup file.
  3. Delete the overlaps.sqlite database file
  4. Rename the overlaps.backup.sqlite file to overlaps.sqlite
  5. Start the OVERLAPS service