File maintenance: consistency checks, compaction, and recovery

Intermediate

Understand the maintenance operations available for FileMaker files — when to run them and what they actually do.

What you'll learn

  • What each maintenance operation does and when to use it
  • Why the output of Recover should never go to production
  • How regular backups reduce the need for emergency recovery

FileMaker files accumulate fragmentation and occasionally suffer corruption. Three maintenance operations address these issues: Consistency Check (read-only integrity scan), Compact (reclaim wasted space), and Recover (extract data from a damaged file).

1/3
1

Consistency Check

A consistency check scans the file for structural integrity errors. Server runs this automatically on open if the file was not closed cleanly. You can trigger it manually from Admin Console via a Verify schedule (see the Verify Schedules lesson). A clean consistency check does not guarantee data correctness — only structural integrity.

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo