• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Troubleshooting > File Maintenance and Recovery

File Maintenance and Recovery

A corrupted database system is every developer's nightmare, as well as every user's. Database systems are complex, and very sensitive to the integrity of their data structures. Errors in the way data is written to a database can damage a system, or in the worst case render it unusable. Periodic maintenance can help you avoid file structure problems. In the worst case, if one of your files does become corrupted, FileMaker has tools to help you recover from this situation as well.

File Maintenance

As you work with a database file, the file can become slowly more fragmented and less efficient over time. Large deletions can leave “holes” in the file's data space. Heavy transaction loads can cause indexes to become fragmented. If your databases are large or heavily used, it's a good idea to perform periodic file maintenance.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint