Subject Re: GBak does not fix problem....
Author phil_hhn
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
> --- In firebird-support@yahoogroups.com, "phil_hhn" <time_lord@h...>
> wrote:
> >
> > Hi, using Firebird 1.5.
> > We had a corrupt database which we could not backup/restore - it
> > complained that there were errors in table BLAH. So we ran GFix and it
> > reported that it found (and removed(?)) 3 corrupt records in table
> > BLAH. Great. However the backup/restore still fails when it gets to
> > this table.
> > Has anyone had similar experiences (or have suggestions)?
> >
> > Thanks
> >
>
> Yep, Last Thursday ;)
>
> http://ibphoenix.com/main.nfs?a=ibphoenix&s=1134931784:189994&pa\
> ge=ibp_db_corr
>
> I thought I was having a mental blank but it turned out gfix was
> unable to repair it. It would be nice if it let you know that rather
> than just completing and giving you the same error next time you
> validate, but that is a topic for another list.
> ....
> HTH
>
> Adam

Thanks for the substantial answer Adam, although in a couple of cases
where we've encountered this problem the database has seemed to be
unrecoverable so we're pretty disheartened. :(