Friday, June 1, 2012

FileMaker Recovery If Multi File Database Approach Does Not Work


As a computer user, you must know the importance and need of a valid backup. It is the best possible solution to safeguard your significant data against data loss. However, there are some situations, where you may find that backup is too big to restore. This problem usually occurs with the database, like FileMaker. In such situations, corruption can cause data loss and you have to opt for alternate FileMaker recovery solutions. 

Consider the following scenarios, which you may run across while working on your FileMaker database, to properly understand the situation:
  •  You discover that your FileMaker database is damaged and it behaves strangely while accessing the data.
  • The database has a number of scripts that you are unable to delete. Every time you try to remove the scripts, the below error occurs:
o   “Script cannot be found”
  • You tried to restore the database from backup, but it takes very long time and process does not complete.
When it happens, you cannot access the database, not even from backup. Such issues lead to severe data loss and require FileMaker recovery Mac solutions to be fixed. 

Solution:

You can try out the following solutions to fix this problem:
  • Split the FileMaker database file in several files. It is basically the best possible solution to deal with large databases. You can split the file and then create relationship between different parts of the files. However, this solution may make your database very complex as you need to maintain and remember the relationships between different files and tables.
  • If you suspect that the multi file approach with cause complexity in the database structure, then you can think of separation mode as a solution. In this design process of FileMaker database, you can keep all your user programming data in one file and all tables, including data, in one file. By using scripting and advanced relationship design, you can make the user feel that both files are being access from one engine.
  • Import the Data Source Tables in a new database and then recreate the indexes. It sometimes fixes the corruption and can also be very quick. Although, there is a bit risk that corruption may carry with the tables that you import, but you can later remove or recreate the affected tables.
If the above method does not help you work around the problem, then you have to opt for advanced third-party recovery applications. Such tools are designed to help you repair and restore corrupted databases of all sizes.

No comments:

Post a Comment