Subject Re: [ib-support] --* Please Help*--- Database corruption and cannot backup & restore
Author Helen Borrie
At 12:41 PM 08-08-01 +0200, you wrote:

> >
> >Do you have DDL Scripts and backups? the source/ compiled objects for
> >your stored pieces?
> >
> >Without the ability to rebuild your database afresh, you are probably
> >going to need Ann Harrison and her Magic Toolbox.
>Helen, thanks for the reply....
>I have DDL scripts and SP sources, but a lot of the application is actual
>data including blobs, which is a problem. We have fixed a few things and
>could do a backup & restore, but still get an abnormal server termination
>with the problem being the old 'gds consistency check' problem due to
>'decompression overran buffer (179)'.
>The cause of this error is given as the possible incompatibilities of file
>systems. However, we have only transported on Windows platforms. Should
>this be the problem? We have a mixture of Win98SE, Win2K Beta and NT4 SP6.

Couldn't say...were you using NTFS anywhere? did you ever restore the database from a zipped GDB file instead of from a GBK?

Have you run gfix at all? If not and you decide to, make sure you do it on a restored database for which you still have the gbk file. Read up on the gfix documentation and DO come back here and ask about anything doubtful.

>How do we fix the above error? I suppose do a transportable backup on the
>actual server and a restore?

See gfix first. And make sure a NTFS-created database gets restored onto NTFS. And I'd want to avoid the machine with the Win2K beta !!!

>Or is there something in Ann Magic Toolbox that could help? 8-)

There usually is but Ann's Magic Toolbox only works for the magician. ;-)

I'll leave this channel open now for others who have been this route in real life. I've never encountered a corrupted database myself so far, touch wood.

-- helen

All for Open and Open for All
InterBase Developer Initiative ยท