Back up, Back up, Back up, Back up...
Your number one defense against corruption is to make frequent back ups and keep as many copies as you can find storage space for. Corruption can be latent, affecting the behavior of your file long after it first occurs--sometimes only becoming evident when you upgrade your OS or your version of FileMaker. Thus, you may have to work backwards in time through your back up copies, running a recover on each until you find a copy that is not corrupted. (A binary search method can greatly reduce the number of files on which you have to do this...)
There's already a third party product available that many find useful when checking their files over for possible issues: FmDiff.
Things to keep in mind about Recover:
- Recover does not detect all problems
- Recover doesn't always fix all problems correctly
- Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.
There is a FMP group on Linkedin that have been discussing this.
Unsure if Linkedin account is required to view this discussion.