Our FMP database is hosted on an iMac, and somehow, it restarted in the middle of the day with users connected to several of the databases.

After that, the server never actual run again because it checks the "integrity" and stuck on forever.

We able to open each databases individually on the server itself. They check the integrity and open.

Is our database corrupt? Our previous FMP Admin set a backup schedule everyday. How difficult is it to restore the data? Is it better to recover or import the data back?

Thank you for your advice,

1. It is possible, that the files were damaged

2. Avoid using files that require recovery

3. Whenever possible, revert to a backup. You can export "new" records from the current copy, and import into the backup

4. re-starting the server does trigger a consistency check, that can take a long time, perhaps 1 or 2 hours, depending on file size

greg

3. Whenever possible, revert to a backup. You can export "new" records from the current copy, and import into the backup

4. re-starting the server does trigger a consistency check, that can take a long time, perhaps 1 or 2 hours, depending on file size

Thank you very much for the advice. We'll recover from our backup then.

Totally new to FMP, so how is the importing prospect working for everyone on 5.5. I don't think there is any problem since it is the same version, but worth asking :

The database that it stucks on is our hardware inventory, but we left the server checks the integrity for the whole day.

Edited December 18, 200619 yr by Guest

More importantly: why did the machine restart? Worth your while to spend some time on that too and see if you need a new (or better) UPS, maybe some hardware piece is failing? ...