DFS - Database Maintenance: Run Compact & Repair

Objective:

Run Compact and Repair/Database Maintenance to improve performance and correct errors in the database.

Compact and Repair and Database Maintenance can speed up the performance of ParishSOFT and correct some other issues. Running these processes is a step in troubleshooting several different issues.

Training Steps:

1. Open ParishSOFT Database Utilities (C:\Program Files (x86)\ParishSOFT\psdbutilities.exe)

2. Back up the ParishSOFT database.

  • Go to the directory containing the ParishSOFT database (which you can find in the top line of psdbutilities).
  • Right-click on the database file.
  • Select Send To>Compressed (zipped) Folder.

3. Make sure all other users are out of the ParishSOFT database.

4. Click Compact & Repair.

  • You will get a warning message: "You are requesting an action which requires an exclusive lock on the database. There CANNOT be any other users or applications connected to the database except this program. When finished this program must be restarted, proceed with your request?"
  • Click Yes. If other users are accessing the database, the Compact & Repair process will return a failure message without affecting the database.
  • The utilities window will stop responding for several minutes and return a message: "Compact and Repair utility completed successfully!" 

5. Click Database Maintenance.

  • A window will open: "Getting ready to run the Database Maintenance utility. Proceed?" Click Yes.
  • The utilities window will stop responding for several minutes--usually longer than the Compact and Repair. When it is finished, you will not get a message but you will be able to close Database Utilities.
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.