Marco Parmeggiani wrote:

> cltan8 wrote:
>
>
>>database file appears corrupt ()
>>bad checksum
>>checksum error on database page 60865
>>
>
>
> try ignoring checksums -i option.

That's not going to work well, unfortunately. InterBase and Firebird
haven't used real page checksums since 1992, but the first thing the
engine does when it reads a page is verify that the value in the
checksum slot in the page header is 12345. The last thing the engine
does before writing a page is put 12345 in that same slot. So, if
there's a bad page, you get the "bad checksum" error. If you turn off
that check, the next error will be something like "bad page type.
Expected (n) found 0." A detailed look at the database will show that
page 60865 is all zeros. That's the symptom of running with forced
writes off on Windows and having the system shutdown hard - unplug the
power with no battery backup.

The ibsurgeon people can normally fix that sort of error.

Regards,


Ann