How to Make Sure Your Sage Timeslips Data Is Valid

By Elaine Marmel

As you work in Sage Timeslips on a day-to-day basis, errors can creep into your Timeslips database. These errors might not be apparent immediately, but eventually they can corrupt your data to the point that the database becomes unusable.

To avoid this situation, you should plan to periodically verify the validity of your database using the Data Verification feature. In many cases, if the Data Verification tool finds corruption, it can repair that corruption.

If the Data Verification feature can’t solve your database corruption problems, you can restore your data from a backup. Or you can contact a Timeslips certified consultant or Sage Timeslips Technical Support person, who might be able to help you correct the corruption. If all else fails, you can send your database to Sage Timeslips Technical Support and, for a not-insignificant fee, they will repair your database.

Typically, you run Data Verification once to simply examine the database for errors. If Data Verification finds no errors, you’re done. If the tool finds errors, you rerun the tool using different settings. The Data Verification process can take considerable time, depending on how much data you store in the Timeslips database. Plan to run Data Verification during an off-peak usage period, perhaps at the end of the workday.

To run the Data Verification tool, follow these steps:

  1. Choose File→Data Verification.

    Timeslips displays the Data Verification dialog box.


  2. Select only the Look for Errors check box.

  3. Click OK.

    A message appears, explaining how data repair works and asking if you want to start repairing data. The message is a bit misleading because Timeslips won’t repair any errors it finds during the process of looking for errors.

  4. Click Yes.

    Timeslips prompts you to make a backup of your database. Because the Data Verification tool won’t make any changes, you can skip the backup this time.

  5. Click No.

    The Data Verification tool begins to run, and you see a progress bar. When the tool completes its analysis, the Data Verification Results window appears.


At the top of the Data Verification Results window, Timeslips reports the number of errors that were found. You can scroll down in the window to review the tests that the Data Verification tool made and their results. This report can be useful to Timeslips–certified consultants or Timeslips Technical Support personnel if you need to contact them for help repairing the database.

If the Data Verification tool reports errors in your database, repeat the preceding steps, making the following changes:

  • In Step 2, select Look for Errors and Rebuild Data Indices.

  • In Step 5, click Yes and make a backup of your database.

The Data Verification tool will attempt to repair any data index problems in your database. If the Data Verification tool still reports errors in your database, repeat the previous steps but, in Step 2, select Look for Errors and Rebuild Data Indices.

If the Data Verification tool continues to report errors, rerun the tool, this time selecting Look for Errors, Rebuild Data Indices, and Validation Errors.

If your database errors pertain to accounts receivable balances or funds balances, you can use the settings at the bottom of the Data Verification dialog box to rebuild those balances for one or all clients.

Although the Data Verification tool will attempt to repair as many errors as it can, it cannot repair all errors. If your database is badly corrupted, the Data Verification Results report will recommend that you restore your database from a backup.