File Corruption can be hidden for long periods of time until something triggers a problem and an error pops up. While using a file for most of a year while damaged is very unusual, it is not impossible.
Best, safest option is to find newest backup copy that does not report this problem when recovered, save a clone of it and then import all the data from a recovered copy of your current file.
Thank you for answering.
When I try to import from the "damaged" file to that last know good copy, I also get this message: "The access privileges in this file have been damaged or possibly tampered with.
Please contact FileMaker Technical Support if the problem cannot be resolved."
FileMaker's locking us out of a year's worth of data.
Is this the original copy or the recovered copy?
If it's the recovered copy, you may have a serious problem. How old of a back up can you open (not recover) without encountering this problem. That may be the oldest copy you can access.
There are no recovered copies; they all gave the same message while trying to recover.
We just have a very old working backup and a bunch files that won't let us open, recover, or import.
Apparently, this file was running along happily as long as it stayed open.
All of the backups cannot be recovered as well?
How do you make back up copies?
All the backups have the same problem and act just like the current file; they won't open.
Server schedule makes the backups locally. These later go to tape backup.
Are these damaged copies from the tape back up? What method is ued to move the backups to tape?
What I'm checking on here is whether you have back up software that is making copies from the open files instead of the closed files generated by the server back up schedule. Such files could easily have been damaged during the backup process.
They look like good copies of a damaged file, since they all behave the same as the current file on the sever. I'm not sure exactly how the server guys get their backups; I know that they only backup the Backups folder after the FM Server finished backing up. The other 80 files are reopened and their backups seem okay.
Right now, I think the biggest mistake was leaving these on Server 8, because I think our 11 Server might have warned us.
I'd check to see how this is done. It won't repair your damaged file, but it may help prevent a repetition of the issue.
Ideally, 3rd part backups should be set to copy the most recent back up copy produced by a server sheduled backup and should not refer to the actual hosted file.
We got that part. 3rd party backups are set to only copy the back up folder produced by FM server's sheduled backup and does not refer to the actual hosted files.
Exactly the same problem here - restarted the server, one of the dozen or so databases was damaged and won't reopen, and the past 3 weeks of backups are similarly dead. Did you ever get a resolution to this problem? I'm at my wit's end, and would like to know how to avoid it in the future. Sympathies! (My posting is at Error 808 - Access privileges damaged)
Have you ever heard of a product called "Stellar Phoenix Filemaker Recovery"? Their free download was able to see my corrupted database, which Filemaker can't. I'd like to know a bit more about them before springing $169 to buy it, though.
What version server do you have, Nick?
Our issue occurred on 8, and we're hoping that when we migrate these to the 11 server, that the consistency check will warn us about things like this when they start, not after finally restarting an otherwise stable server. (I should test this with the bad file on server 11.)
No resolution to the corruption yet other than FileMaker's File Recovery Service, which we're beginning to look at now: http://help.filemaker.com/app/answers/detail/a_id/1633/kw/1633
The folks that produce FM Diff also offer a file repair service. I haven't had any dealings with them, so can't recommend for or against them, but you might also check them out.
I'm using FMS 11, the most recent (and the only one that runs on the current Mac OS). I didn't know about the feature of email notifications; I've now turned those on, and hopefully if something gets corrupted, at least I'll know about it soon.
I'll buy Stellar Phoenix and let you know if it works for me. $169 (academic) vs. %500 is a significant difference.