Table of Contents

OST - 20.05.02 Database Maintenance - Compact and Repair

Views: 3494 Last Updated: 07/24/2023 01:49 pm	100 Rating/ 1 Voters
Be sure to rate this article 5 Stars if you find it helpful!

With normal use, a database may start exhibiting unwanted behavior and may perform slower. To keep your database in optimal health, On Center Software recommends that you run a Compact and Repair on all production databases regularly.

SQL Databases

If you are using SQL databases, there is a function called "Shrink" that the SQL Administrator uses to reduce the size of a database, as needed. Running the Compact and Repair routine on SQL databases is still required as this reorganizes the database and keeps the database running efficiently. Compacting and Repairing an SQL database should only be performed by the SQL admin. Compact and Repair clears the database's log file (LDF file) - this reduces the overall size of the database file set but does not free-up unused space within the database itself.Although there are no hard and fast rules about how often to Compact and Repair a database, every week is a good place to start. If you do a lot of copying and pasting between bids/databases, or a lot of importing/exporting of Bid packages/change files, more frequent maintenance is required.

Running the Compact and Repair routine optimizes your database and there are no 'ill' effects to running it frequently.

Compact and Repairing a Database on Demand

Note

All users except for the person running the Compact and Repair, must close the application before starting the Compact and Repair process.

Click File > Open - the Open Database dialog box displays

OST Open Databases dialog box

Highlight the database on which to perform maintenance and click the Compact/Repair button - a confirmation displays when the process is complete

OST Compact and Repair complete pop up

If your database requires Login, you will have to enter your credentials to log back into to the database after performing a Compact and Repair.

Note

To perform a Compact and Repair of a database quickly, right-click the database on the Bids Tab, and select Compact/Repair from the Context Menu.

Even if you are using SQL databases, you must run "Compact and Repair" from OST regularly and run "Shrink" from the SQL Admin Console.

If you receive an error message indicating that the Compact and Repair cannot be completed, close the program and make sure there are no other users using the database, then re-launch the product and try to compact and repair the database again.

Setting up Automatic Compress

Automatic compress settings attempt to keep Access-type databases at an optimized size.

Caution

This process only makes the database size smaller, it do not correct structural issues or optimize the function of the database. It is important to manually run the Compact and Repair routine on all databases regularly.

Click File > Open - the Open Databases dialog box displays

Select the appropriate database and click Properties - the Database Properties (Access) dialog box displays

OST Database Properties dialog box (Access database)

In the Auto compress field, select the frequency at which the program should automatically compress the database (default is monthly)

The auto-compress routine runs when the application is closed, any open databases are compressed based on their Auto compress settings.

Database Maintenance - Upgrading Databases

Database Maintenance - Synchronizing Databases

Classic Products Best Practices - OST QB DPC