FasTrax Solutions - Product Documentation
Close Tab and return to FTX lifeline Copyright ©2017 FastraxPOS, LLC.

FasTrax POS Lifeline Documentation

Database Maintenance Steps

  1. Check only –

    Clear Sent Queue Records – not available in store mode
    Clear Temporary Report Tables

    Choose the "Perform DB Maintenance" button.

    This can take a few moments - you will be notified when the process is complete.

    This step can be performed regularly without having to run step 3.

  2. Check only –

    Clear Sales Data Older Than
    Select the date you wish to clear data from
    Clear Old Snapshots

    Choose the "Perform DB Maintenance" button

    For your protection, this step requires a password supplied by FasTraxPOS Technical Support
  3. Check only –

    Rebuild Indexes
    Shrink ILSA_SQL
    Shrink Queue – not available in store mode
    Shrink POS Receipts – not available in corporate mode
    Shrink Ticket Number – not available in corporate mode

    Choose the "Perform DB Maintenance" button.

    This can take a few moments – you will be notified when the process is complete.

    Maintenance is now complete!
    You may now resume normal business operations.
    You may notice options not available. Some of the above options are only available depending on your database type – corporate or store.
    Please remember, maintenance plans need to be executed during non-store hours. Depending on regularity and database size, the time needed to complete could be extensive.