How To Check Your Database

In your computer system, both hardware and software are tools. Like any tools, they require regular tune-ups to run smoothly. Checkups prevent minor difficulties from escalating and possibly causing system down time.

To Run A Check

This is a passive process and can be run with users in the system.

1. On your server, navigate to the Collect!\bin folder.
2. Run checkSQL.bat.

For simplicity, this process has been scripted using a batch file. You can schedule this file to run periodically with the Windows Scheduler.

Some processes may take quite a while depending on the size of your database.

In Collect!, if you go to the File menu, then to Maintenance, the Check Database button will run this script.

When the check completes, the results will be output into the Collect!\bin\check.repair file. By default, we have disabled the MS Check's info messages. This means that if there are no errors the file will be empty. If there are errors, the file will populate with the details of the errors.

If your database has errors, Microsoft only has 2 options available: restore from your last backup, or contact them to attempt a restoration. Database issues should be handled by a Microsoft Certified Technician.