AnsweredAssumed Answered

huge size Filemaker database with no records

Question asked by andrewfilemaker on Jan 4, 2018
Latest reply on Aug 14, 2018 by KeithProctor

I have this file with no records but is at 22 GB. I wonder is there a way to fix it?

Here's a few facts about the file.

1. 34GB with records, reduced to 22GB after saving as a clone(No records)

2. Passed consistency check, and there was no error when using filemaker recover function.

3. file is still 22GB even if I delete everything including table, relationship, scripts, etc.

4. file seem to be a sparse file after inspecting it with terminal command "ls -ls"

44394392 -rw-r--r--@ 1 imac2014  staff  22729928704 Jan 3 16:43 35764.fmp12

it's taking 44MB disk space. But the size is 22GB.

 

Is it possible to fix it without rebuilding the database? Thanks.

Outcomes