Tuning up a company database

Tuning up your company database optimizes your company data to help it run efficiently and without errors in Sage 100 Contractor.

Your database is tuned up automatically during nightly maintenance according to the schedule you specify on the Create Maintenance Schedules or the Modify Maintenance Schedules tab. However, you can also tune up your database on demand from the Tune Up Company Databases tab.

Before you tune up a company database

Make sure no users are logged in to the company. Sage 100 Contractor will terminate their connections 60 seconds after you start the tune up. Terminating connections in this way can cause problems if a user is actively working in the company when their connection is cut off (for example, if they are posting payroll to the general ledger or working in an estimate that they haven't saved recently).

To tune up a company database on demand:

  1. Click Tune Up / Back Up / Restore > Tune Up Company Databases.
  2. On the tab to the right, select the company or companies you want to tune up.
  3. Click [Tune Up Databases].

Note: Any users who are logged in to the database when you perform a tuneup are warned that they will be disconnected in 60 seconds. Terminating connections can cause problems if the user is actively working in the company when their connection is cut off (for example, if they are posting payroll to the general ledger or working in an estimate that they haven't saved recently.