Subject Database error caused a full table to be lost, can it be recovered
Author cprund
Hello everyone.

I just ran into a bad case of database corruption. On the surface it
really did not look that bad since "gfix" only showed errors in 2
data pages and 3 index pages.

So I've done the usual:

gfix -shut
gfix -mend
gbak -B
gbak -R

Restoring failed, I guess at the time it started restoring my stored
procedures, because a table was missing. I opened the database after
"mend" and sure enough, one table was gone! Unfortunately that table
is fairly important for my application and I can't recover without it.

Is there any way to recover from such an error? Is there any tool,
freeware or comercial that can help me deal with such a problem?

P.S: This is not a database we "run in-house", it's a database from
one of our clients. I don't think they have a recent backup.

Thanks,
Cosmin Prund