Subject | Re: [firebird-support] Database corruption, please help |
---|---|
Author | Sudheer Palaparambil |
Post date | 2006-11-16T18:31:56Z |
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
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]