Run FH Database Tools

You need to run FH Database Tools to compact the live database and rebuild database index files.

Warning: Before beginning, verify that all FIREHOUSE Software users are logged out, and that FIREHOUSE Software is not running.

  1. Choose Start → Programs → FIREHOUSE Software → FIREHOUSE Software Database Tools.

    The Database Tools - FIREHOUSE Software dialog box appears.

    Note: (FH Enterprise) Selected Database lists the name of the SQL database to back up. If Connect to Remote Database is selected, Rebuild Index Files is renamed Rebuild Remote Folder and Check Remote Database.

  2. Verify that the path displayed in Selected Database is the correct location for your department’s live database, and edit it if necessary.

    Note: We are using the DemoData database for example purposes in these instructions. Use your live database when running Database Tools.

  3. Click View Active Logins.

    The Active Logins - FIREHOUSE Software dialog box appears.

  4. (If any login records are displayed in the Active Logins dialog box) Click Attempt to Clear Invalid Logins.
  5. Click OK to return to the Database Tools - FIREHOUSE Software dialog box.
  6. (FH Standard Edition) Select Compact Tables and Rebuild Index Files, and then clear any other check boxes.
  7. Click Run.

    Progress updates appear on your screen. This process may take some time if you have many records or a large database.

    Note: If errors appear and you need assistance resolving them, contact FH® technical support.

  8. Click Close to close the Database Tools dialog box.
  9. Continue with Backup your FH database.