In certain cases (sometimes after an update has been installed), the log file associated with the ESHA Database becomes damaged or corrupted, causing searching in the program to be unreliable. In this scenario:
- Close your ESHA software.
- On the server which hosts your database, launch Database Utility (found in the Windows Start menu, under ESHA).
- Connect to the SQL Server & database.
- Backup the database.
- After backup, click Database / Shrink.
- Exit Database Utility.
After the above, launch your program try searching again.
Advanced: If using your own instance of SQL Server, or you have SQL Server Management Studio (Express) installed (a free download from Microsoft), you can force a rebuild of certain indexes which may help searching and you can shrink the database log file. Specifically:
- Using Management Studio (Express), connect to the proper SQL server instance, and open the ESHA Database.
- Expand Tables.
- Expand BaseFoodName table.
- Right-click the Indexes listing, and choose Rebuild All.
- Click OK to the Rebuild Indexes dialog.
- Then right click on the database, and go to Tasks>Shrink>Files
- Change the "File Type" to Log
- Under "Shrink Action" choose reorganize pages before releasing unused space, and enter in a "Shrink file to:" value of 0
- Click ok to shrink the log file.