After running Recovery on database file I discovered that more than half of the records in one of my tables had been deleted. My discovery was found using my backup file.
The setting used for Recovery are in the attached file.
What does the log file (Recover.log) have to say about this ?
Recovery is meant to remove all suspect things from the file in an attempt to give you a file that can be opened. So it would indicate that your file is in bad shape...
as wim said. if recover removes records then your file is trash
I don't have a lot of experience with using Recovery and it's log file, the few times that I've run Recovery I've never had a problem.
The reason I'm running it now is because of intermittent crashes and slow performance.
The log file indicates that Recovery is "Recovering indexes for a number of tables.
rtolliver wrote: intermittent crashes
Make sure to revert to a backup after a crash.
Is this FMS crashing? If so what does do the logs say?
This is very unusual, and a bit troubling
Which FileMaker Version, and which OS ? About how many records were removed ?
When Recover was done, didi it say if the file had any "Problems" ?
In general, the purpose of Recover is to get your DATA back, not your file, and that did not happen here
You also did select the most conservative setting: Compacted Copy
Please contact Tech Support, and ask them to explain this ( and let us know what they say )
Please insist that they look at your file
Important: Make sure the records removed did exist, e.g. that a scrambled index was not perhaps displaying "Phantom" records ( with all question marks )
> After running Recovery on database file I discovered that more than half of the records in one of my tables had been deleted
gdurniak wrote: In general, the purpose of Recover is to get your DATA back,
In general, the purpose of Recover is to get your DATA back,
An important nuance perhaps: the purpose of Recovery is to get *as much of* your DATA back *as possible*
Another thing to check: does one of your backup schedules use the "verify" option? And did it ever report any issues?
Retrieving data ...