Hi Ann

Thanks for responding. This is the best I could get out of the
client. I have asked him about the situation multiple times, phrasing
the questions differently but this is about all I got from him.

Is there a recovery tools or some kind of create database that would
help me get the best part of the data back?

I just got a copy of the corrupted database and tried to open the
table in FlameRobin and I get the following message:
---------------------------
An IBPP error occurred.
---------------------------
*** IBPP::SQLException ***
Context: Statement::Fetch
Message: isc_dsql_fetch failed.

SQL Message : -901
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements

Engine Code : 335544329
Engine Message :
invalid BLOB ID

---------------------------
OK
---------------------------
If I okay this message I still can see the data in the table but I am
not sure which records are corrupted.

Please advise.

Regards

Bhavbhuti

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> Bhavbhuti Nathwani wrote:
> >
> > He recently sent a big print job from the app and realized that it was
> > the wrong job. So he closed the printer and regular Windows messages
> > followed. According to him the app itself did not terminate
> > abnormally. I have no idea why such a situation would corrupt the
> > table in the FireBird database. Currently he has restored a backup
> > and is back on his way.
>
> Even if the whole system crashed, Firebird should not corrupt the
> database.
>
> >
> > Do I have to make any adjustments to the database? Is there any way
> > to recover a corrupted table?
> >
>
> If you described the errors more completely, you'd get better
> advice.
>
> Good luck,
>
> Ann
>