I have a set of FactorySQL 4.2.12 running in redundancy mode, recently, The Master Server, started showing incorrect behavior, The Front End interface would take forever to Load, the groups were not triggering properly, If I would stop the FactorySQL service, everything on the server would be OK, but when factorySQL was started, it would seem as if the OS would Hangup for moments and Front End would be terribly slow in cases of loading property windows etc. Needless to say that it was a disaster. I tried using system restore but that didnt help either. The Front End Log file had entries like (Failed to Upgrade internal database…)
Now once I uninstalled and reinstalled FactorySQL (and deleted the folder from the program files), everything became ok.
So I am assuming that the configuration files were corrupted. Can you please comment as to how to avoid this or recover from this, without reinstalling.