Afternoon all,

> try this :
>> gfix -mend -full -ignore database.fdb
> Next, check if there's still errors :

You are aware of exactly what -mend does to a database aren't you? I
wouldn't ever run it on a live database, only on a copy of a "corrupt"
database.

Once data are "removed" from a live database, it's gone forever. The
-mend option doesn't actually "fix" things, it simply makes the database
available for backup - probably by deleting broken stuff!

The gfix manual page at
http://www.firebirdsql.org/manual/gfix-dbverify.html has details.

You might get away with -mend if you also specify -no_update.


Cheers,
Norman.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767