Hi Milan,

In url
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.PAGES;NAME='ibp_d
b_corr'

has a paper named "Diagnosing and Repairing Interbase Database Corrupion"
updated and revised 29th Sep 2000 by Paul Beach.

I´ve repaired some database using the commands this paper..

Good Luck.

Marcelo

> ----- Mensagem original -----
> De: Milan Babuskov [SMTP:milanb@...]
> Enviada em: quarta-feira, 19 de fevereiro de 2003 04:55
> Para: ib-support@yahoogroups.com
> Assunto: Re: [ib-support] Re: Internal gds ... problem
>
> Aage Johansen wrote:
> > "Milan Babuskov " wrote:
> > > I made some updates to my database DDL, and once I disconnected, I
> > > cannot reconnect again. I get this error from isql:
> > > Statement failed, SQLCODE = -902
> > > internal gds software consistency check (decompression overran buffer
> > > (179))
> > > Server is Firebird 1.0.2.
> > > I cannot gbak, or gfix, both throw the same error as above.
> > >
> > > Any suggestions how to save the data in this database?
> > > It's is not very important (I can reproduce the data with some
> > > effort), but it would be better if I could get it back.
> >
> >
> > You could try "gfix -mend ..." followed by backup+restore. May - or may
>
> > not - work.
>
> Already did. Gfix quits immediately without doing anything.
>
> > Have you considered ibsurgeon (from devrace)?
>
> I have downloaded it yesterday, and run it, but didn't know what to do.
> I didn't even know where to look for error.
>
> I have some backup of that database (about 16 hours of work is lost), so
> the data will be reentered. I just wanted to extract data from broken
> database to make sure nothing is missed.
>
> Thanx.
>
> Milan.
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>