There is really no way that this can be done other than by technical support. They have a tool they use that can repair those damaged tables. A better questions would be how to prevent the problem from occurring in the first place.
Database issues are typically caused by premature shut down of the program or computer, and power fluctuations and outages. So a couple of things things you can do:
1. Make sure you have an uninterruptible power supply (UPS) on the main machine where these database files reside.
2. Make sure you don't just press the off button on the computer without doing a proper shutdown through Windows.
Remember that the island is synchronizing every two minutes. So if the island is trying to sync and touching/updating/retrieving information from the tables and the system stops, then you are going to potentially have corruption of the database(s).
Hope that helps.
glowfish wrote:Yes. Tried to fix it myself. Needed support to fix logs. Would love a set of instructions if I had to do it again.
Thanks!