ok thanks for that, found exactly what i was after.

The log file had the following in relation to the gfix command

Mon Apr 18 14:11:37 2011
Database: /ibdata/repaircopy.fdb
Index 1 is corrupt on page 649417 in table POINTMAN_PART_FULL (155)


Mon Apr 18 14:11:37 2011
Database: /ibdata/repaircopy.fdb
Index 1 is corrupt on page 649417 in table POINTMAN_PART_FULL (155)


Mon Apr 18 14:12:18 2011
Database: /ibdata/repaircopy.fdb
Record 1226004 has bad transaction 68538 in table BATCH_REC (290)


Mon Apr 18 14:12:18 2011
Database: /ibdata/repaircopy.fdb
Record 1226414 has bad transaction 68571 in table BATCH_REC (290)


Mon Apr 18 14:12:18 2011
Database: /ibdata/repaircopy.fdb
Record 1226414 has bad transaction 68568 in table BATCH_REC (290)

We have dropped and rebuilt the indexes ok but what does the other error mean "Record 1226414 has bad transaction 68568 in table BATCH_REC (290)" Does this mean that the table "BATCH_REC" is now corrupt?

thanks

--- In firebird-support@yahoogroups.com, "karolbieniaszewski" <liviuslivius@...> wrote:
>
>
> --- In firebird-support@yahoogroups.com, "crizz11" <crizz11@> wrote:
> >
> > on running the command
> > gfix -v -full repaircopy.fdb -username "username" -password "password"
> >
> > we see the following results.
> >
> > gfix -v -full repaircopy.fdb -user -password
> > Summary of validation errors
> >
> >
> > Number of record level errors : 3
> > Number of index page errors : 2
> > Number of database page errors : 1
> >
> > How would I go about finding out more information about each of these errors listed.
> >
> > We did a dump and reload of our databas on Friday 15th because our database file had grown in size to 7.1GB. After reloading the database was sitting at 5.3GB (normal). Already by today Monday 18th it has grown to 6.1GB. There is no way we are generating this amount of data as it has taken us 7 years to get to the normal 5.3GB size. When we did the check on the 7.1GB database file the above error report had much higher numbers. Anyone got any ideas as to what might be happening here?
> >
> > thanks
> >
>
> Detailed info after gfix work is in Firebird.log in installation dir
> About reason of errors - what detailed version of Firebird you use?
>
> Karol Bieniaszewski
>