Repairing a Corrupted Database

Use the following steps to repair a corrupted Pervasive database file:

  1. Make all users for this database exit the program.

  2. Launch the Administration module.

  3. For the User name that is experiencing the problem, find the Configuration assigned to that user.

  4. Review the file paths for this configuration.

  5. Determine the data file(s) you want to recover. The most commonly corrupted database files are:

File name

File contents

File path (in Administration)

Vdata.dat
Vdat_aux.dat

Data

SPC Data

Vnote.dat

Notes

SPC Data

Vstds.dat

Standards

SPC Standards

Ddata.dat
Ddat_aux.dat

Data

DMS Data

Dnote.dat

Notes

DMS Data

For a full list of database files and their contents, see Tables and Files Used in GainSeeker 8.

  1. Back up the database file(s) you want to repair.

  2. Launch the Pervasive Tools.

  3. Click Open, and select the database file you want to repair.

  4. Click Recover. After the recover has finished, it will display the number of records recovered.

  5. Click Close to close the file.