Subject Re: [firebird-support] Database corruption, please help
Author Sudheer Palaparambil
Hi Ann,

Thank a lot, It worked, I was able to pump the data from the corrupted
database,
only a very few records were lost.

Thanks again.

Sudheer Palaparambil


On 11/16/06, Ann W. Harrison <aharrison@...> wrote:
>
> Sudheer Palaparambil wrote:
> > Hi,
> >
> > When I try to back my database, gbak is aborting with the following
> error
> > ..................
> > ..................
> > writing data for table PURCHASE_DET
> > ERROR: internal gds software consistency check (cannot find record
> > fragment (248))
> > ERROR: gds_$receive failed
> > Exiting before completion due to errors
> > ERROR: internal gds software consistency check (can't find after
> bugcheck)
> >
>
> Have you tried gbak with the -g switch? That switch disables
> garbage collection and, with luck, the lost fragment will be in
> a back version, allowing you to get a clean backup. If that
> doesn't work, you can do a metadata backup, create an empty
> database, and pump data from the broken database into the new
> database. A little experimentation will show you where the
> corruptions are in the PURCHASE_DET table so you can use an
> index lookup to avoid them.
>
> Regards,
>
> Ann
>
>


[Non-text portions of this message have been removed]