Subject | Re: [firebird-support] Database corruption, please help |
---|---|
Author | Ann W. Harrison |
Post date | 2006-11-16T18:00:34Z |
Sudheer Palaparambil wrote:
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
> Hi,Have you tried gbak with the -g switch? That switch disables
>
> 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)
>
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