Why does Sage 2008 get corruptions in first place and can they be fixed by us and not Sage?
Posted on 2008-10-20
When we backup Sage each evening we always run a data check to ensure no corruption. On two occasions, last Friday and about a month ago, it came back with error. The message normally goes along the lines of certain transactions references do not balance. This should be impossible, and clearly shows corruption within the data.
There are only 2 options to resolve the issue. One is to upload the program data as a file to Sage who have their techies fix it for free (part of insurance we pay) but it takes up to 3 days and we would not be able to use sage until they return the corrected data! They can usually do this without losing any of the work done that day.
They're only suggestion is that a power surge might be involved. But this is a network - with normal network traffic? Surely the Sage techie is relating his/her answer to a server actually being offline at any given point i.e. hard reset mid way through operation.
The second is to reload the last uncorrupted backup (in our case the day before), which obviously means that the work is lost but is the quicker option.
- Why does this happen?
- How can you tell which type of database, be it Access or SQL, you have - we do have SBS 2003?
- Can it be fixed manually?
- I have seen an EE answer suggesting a program which backs up every hour or so? Any thoughts on this?