Running Document Management System database repair utility DBRepair
by Intuit• Updated 8 months ago
Occasionally, when working in Document Management System (DMS), you may need to perform a database repair to make sure the database is functioning properly. There are a few methods to use, but this article explains the easiest and most effective one.
Use these steps to resolve the following issues:
- DMS is running very slowly
- Scanning is slow or unresponsive
- Error messages reference "DBISAM"
- DMS closing while working in the program
Other issues can cause these error messages, such as Windows security settings on your server or third-party applications (including anti-virus software) causing interference with the database. If you run a database repair and it doesn't resolve the issue, contact our support team.
DMS database repair will fix issues, but it won't prevent them from happening in the future. To prevent future incidents, make sure that you've reviewed all of the information in Lacerte system requirements.
To repair your database
Before you start
Before running the DBRepair utility, it's essential to have a current backup of your database.
To backup your DMS database files before the repair:
- Browse to the folder where the DMS database is kept.
- If you're not sure where your database is located, look at Current Database Path in the program window.
- If you're not sure where your database is located, look at Current Database Path in the program window.
- In the folder containing your database, select all the files ending in .DAT, .BLB and .IDX.
- From the Edit menu, select Copy.
- Create a new folder on the root of your C: drive and name it DMSBACKUP.
- Open the C:\DMSBACKUP folder and paste the database files there.
Keep in mind this isn't a complete backup. It only allows you to recover files if there's a problem with the repair process. For a complete backup, you'll also need to copy the Details subfolder, which may be a large folder.
Follow these steps to begin the repair using the Tool Hub:
Step 2: Using the tool in the Lacerte Tool Hub
- Open the Lacerte Tool Hub.
- Select DMS on the left.
- Click on DMS Database Support Utility.
- Follow the on-screen instructions to run the tool.
Many folders inside the folder structure may cause slowness. See Improving performance in Document Management System (DMS) for instructions.
Sign in now for personalized help
Ask questions, get answers, and join our large community of Intuit Accountants users.
More like this
- Bitdefender is blocking or quarantining data01a.idx from the DMS Databaseby Intuit• Updated December 11, 2023
- Troubleshooting DBISAM engine error 9217 - Error opening DMSby Intuit• Updated December 05, 2023
- Document Management System Intuit Hosting onboarding and setup guideby Intuit•3• Updated 4 weeks ago
- Backing up a DMS database before a repairby Intuit•3• Updated December 05, 2023