Summary
Using File Doctor to fix data corruption in Sage 300 CRE.
Resolution
Follow the steps outlined below to check your data using the File Doctor tool.
Prerequisite
- Have all users exit all Sage applications and restart the File Server
- Verify that the free disk space is twice the size of the file you're fixing
- Review information for locked files for low disk space
Prepare to use the File Doctor
- Log in to the Sage file server with the admin user.
- Stop the SQL Replicator, if you're using it.
- Back up your company data.
Use File Doctor to fix your data files
- Open Sage Desktop.
- Go to Applications, Common Tasks, Tools, and File Doctor.
- Select the Current data folder to fix specific files.
- In the Tasks section, select the Fix and compact bad files and Compact good files checkboxes.
- Then, select the desired files in the Files list.
- Under Printer Information, click Printer Setup.
- Select Print to file and click OK.
- Click Start to begin fixing the files.
- In the Print File Selection window, type a name for your summary report and click Save.
- Review your report to ensure all the fixes and any data loss.
- Restart the SQL Replicator, if you're using it.