Database Tools

Routine database maintenance will minimize the errors you encounter while using FH.

Warning: Database tools should be run outside of FH, with everyone logged off.

  1. From the Windows Start menu, select Programs, then the FIREHOUSE Software folder, then FIREHOUSE Software Database Tools.

    Caution: While you can also run basic database tools from inside FH, from the Tools menu, Database Tools option, any open files will not be modified (users and security) when database tools is run while FH is open.

  2. Select the database you want to perform maintenance on.
  3. (In an FH Enterprise installation) Check Connect To Remote Database.

    Caution: If you modify FIREHOUSE Software tables using an application other than FIREHOUSE Software, the verification may fail.

    Warning: Make frequent backups, as not all corrupt file errors can be corrected.

  4. Check Validate File Locations to check for FH files located in invalid locations (not available for FH Enterprise).
  5. CheckCompact Tables to physically remove deleted records and compress narrative and memo fields.
  6. Check Rebuild Index Files to rebuild index files.

    If you receive the Record out of Range or Record is not in index error, re-indexing will correct the problem.

  7. Check Verify Logical Integrity to verify that FH tables meet logical and consistency rules.

    Note: This will verify all database audit records, and may take some time.

  8. Press View Active Logins to view a list of active logins.
  9. Contact logged in users to have them log off to ensure complete maintenance.
  10. (If there are logins listed that you believe are invalid) Press Attempt to Clear Invalid Logins.
  11. Press Run to perform selected options, or press Close to exit without performing any actions.

    If you press Run, you are prompted to append to the log file.

  12. (If the prompt appears) Select Yes to add details of the database maintenance to the end of the existing log file, or select No to create a new log file (the existing log is overwritten).