Subject Re: [ib-support] corrupt data base
Author William Hill
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,

> 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
> We have answers.