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.