Table rebuild tool

Concepts

NexusDB is unlike SQL Server and Oracle in that it can be used in single-user standalone mode, with VSys writing directly to the database tables itself. Even when using NexusDB Server, NexusDB tables are more prone to file damage than those used by SQL Server and Oracle. This tool provides a mechanism for verifying and repairing possibly damaged tables.

The first sign that something may be amiss with your tables would be an error like:
exception message: NexusDB: <unnamed TnxTable instance>: Read failure[$2401/9217]

Your first course of action is to call or e-mail. We can read the error report and tell you which (if any table) has a problem. If this is not feasible due to time zone issues (or it's a weekend or holiday), you can follow the repair process yourself on all tables – no damage will occur if you repair an undamaged table.

Always make a backup of the underlying files (*.nx1 files) before using this tool.

Steps in this task

1. Get all other users out of VSys, this includes closing down VOXI and the Standalone E-mail Robot if you're using them. This tool can only be used if no other users have any tables open.
2. Back up your data. Do this by backing up the underlying *.nx1 files rather than the VSys One backup tool since that tool may not be able to capture all records from damaged tables.
3. Get to the database selection window and choose the database to work with. If VSys starts without prompting you for which database to use, hold down the left Ctrl key while VSys starts up. This will force VSys to prompt you for a database, allowing you to use this tool.
4. Click on the Tools link then select Verify and repair NexusDB tables in this database.
   
5. Select which tables to verify.
6. Click Rebuild.

VSys will now check each table and report back the results of its progress.