How_do_I_maintain_databases_

How do I maintain databases?

You can use Connect to rebuild indexes and shrink the database size. Use rebuild indexes to improve the database processing speed. Use shrink database to compact the database so less disk space is required. Using these tools on a regular basis will help Connect databases run more efficiently.

 

Before you get started

 

Rebuilding a database

1. Open Connect System Management > System Tools > Maintain Databases.

2. From the Server menu, select the server with the databases you wish to service.

All of the databases on the selected server will be displayed in the Database field.

 

3. Select the Database:

  • Click on a database to select it, or

  • Press and hold CTRL to select more than one database, or

  • Click Select All. 

 

4. Select the Rebuild Indexes checkbox to improve the database processing speed.

Rebuild indexes removes fragmentation and reclaims disk space.

 

5. Click GO (CTRL+G).

The database is defragmented.

 

Shrinking a database

1. Open Connect System Management > System Tools > Maintain Databases.

2. From the Server menu, select the server with the databases you wish to service.

All of the databases on the selected server will be displayed in the Database field.

 

3. Select the Database:

  • Click on a database to select it, or

  • Press and hold CTRL to select more than one database, or

  • Click Select All. 

 

4. Select the Shrink Database checkbox to compact the database size.

Shrink database recovers space by removing empty space.

 

5. Click GO (CTRL+G).

The routine recovers space in the database..

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • How do I maintain my SQLEXPRESS database?

      If you're a smaller organization that's using the free version of SQLEXPRESS instead of using a paid version of Microsoft SQL Server Standard, you will need to do a little database maintenance to keep everything operating at peak performance. How ...

    • How do I load databases?

      Use Load Databases to restore a backup copy of your Caselle databases. Backup copies are usually stored to a local drive or, in some cases, may be retrieved from the Caselle Support Portal when you work with Caselle Support to resolve a database ...

    • Where can I select the databases a user can access?

      Connect is capable of using different databases to run the applications in the Connect family. If you like, you can pick one database to run Payroll for one user and a different database to run Payroll for another user. If your organization is set up ...

    • Schedule Tasks - Supported Task List

      Supported applications include Accounts Payable Process report Accounts Receivable Process report Animal License Process report Applications Manager Backup databases Delete tracking information Maintain databases Process report Asset Management ...

    • How do I restore a database? (2018.02)

      Restore Caselle databases from a backup copy. See the help topic titled How do I load databases? Copyright © 2025 Caselle, Incorporated. All rights reserved.