Greetings,
Some weeks ago I had a similar situation.
I'd recently procured FMP10. I'd had a number of databases running
under FMP9 that were upgraded to FMP10.
The serving machine crashed and had to be rebooted. There were files
that had not been closed properly. The largest of which had
difficulties with the recovery under FMP10. Data was lost in it. As I
had not modified the database structure I tried recovery under FMP9,
which I had a copy on another machine I could use. It recovered
without any problem. And FMP10 accepted the recovered file.
The next time the computer crashed, it didn't seem to have a problem
with the recovery of that file under FMP10.
No idea what was the problem with the first recovery. Or why the
second recovery worked okay.
Regards,
Chuck
On Feb 19, 2009, at 1:40 AM, MoneyMaker wrote:
Good morning to Everybody,
I have recently updated to Fmp10 and an operating on a Windows Vista
system.
My file contains more than 153.000 records (about 187 MB).
I had a couple of crash recently and the computer shut down and, when
reopening the fmp file the usual "File not closed correctly…. Etc"
check window appeared and the file was reopened without apparent
problems, except that the last 50 or so records inserted were missing.
First question: shoudn't they be there? To be safe it's better to
close and reopen the file after inserting 10/20 records just to be
sure?
But at the last crash and reopening the recovery log said clearly…
"The file should NOT be used for inserting new record, get the last
backup and use this file only to import records there."
And so I did.
Now…I wouldn't mind recovering et al… the terror strikes me at the
even remote possibility to loose all my 153.000 records.
Luckily the backup copy (of some days before) was ok and I was able to
import the last missing records and now it seems all is running
smoothly.
Yet I still lost some informations on part of the fields I recently
added since last backup.
I wonder if, from experienced user, there are some suggestion of a
safe backup and maintenance protocol to be 100% safe that all is done
to prevent data loss.
Should I back up also an empty clone daily? Or is it enough a full
backup copy?
My computer has three internal disk, the main one, the D and E disk.
Is it ok to back up on them? Or better on a fully external source (usb
keys - Writable CD - external hard backup disk)?
Moreover… when I have such backups… one week of them is enough to be
safe (one copy for each day) or it is overkilling the problem?
When I have say, last seven days of backup it is ok to delete old ones
and keep always last seven days?
When I have major changes on the file structure, better to work on a
clone, and then reimport all the datas in it? Or is it ok to make
those changes on the main file (providing a back up is made
beforehand?
Is it useful to save a compact copy of the file? What does it
serves for?
Is it ok to recover the file now and then even if there are no
problems or is it useless?
In the good ol' days of previous fmk version, an advice that
circulated in the list was:
"periodically, recover, save a compacted copy and recover again", just
to overkill…
Thanks for your experienced advice.
MoneyMaker
"The plain art of making money"
