Subject | Re: [ib-support] corrupt data base |
---|---|
Author | William Hill |
Post date | 2001-12-18T22:55:46Z |
Hello Ann,
gbak -v shows that that it is a data error. I will
pump the data over into a new database to cure it.
Many thanks for your help.
Best regards,
William.
gbak -v shows that that it is a data error. I will
pump the data over into a new database to cure it.
Many thanks for your help.
Best regards,
William.
> OK, that's the way these things go - like clearing trails after
> an ice storm. Run gbak with the -v switch and determine where
> the error occurs. If the error is not in the metadata, you can
> run gbak with the -m switch to create an empty database and
> pump all the data except the broken table(s?) into the new
> database. If the broken table(s?) have a primary key, you can
> probe on the key to determine the key values of the broken
> record(s?) - e.g. where pk < 'M' - if that gets the error then
> where pk < 'G' - you remember, a binary search...
>
> Or you can contact me directly - I have some tools that help
> repair databases.
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.