Subject | Data Lose |
---|---|
Author | Tim Wilson |
Post date | 2011-07-14T00:56:40Z |
Hi
We are currently having an issue with a client database that keeps both losing data and getting black entries on certain tables.
We have an Options table which stores all of the system wide settings for our application. For this client their options table is being cleared and all settings are being lost. We also have a Members table which stores all of the user information that is getting black users added to it.
Using Gfix, we have run a validate on the database which didn't show any errors. We then tried a Mend followed by a Backup and Restore to see if this would prevent the issue. However only 10mins after performing these steps the options table was blank again.
Any suggestions as to what may be the cause would be greatly appreciated.
Regards
Tim Wilson
We are currently having an issue with a client database that keeps both losing data and getting black entries on certain tables.
We have an Options table which stores all of the system wide settings for our application. For this client their options table is being cleared and all settings are being lost. We also have a Members table which stores all of the user information that is getting black users added to it.
Using Gfix, we have run a validate on the database which didn't show any errors. We then tried a Mend followed by a Backup and Restore to see if this would prevent the issue. However only 10mins after performing these steps the options table was blank again.
Any suggestions as to what may be the cause would be greatly appreciated.
Regards
Tim Wilson