Subject | Database error caused a full table to be lost, can it be recovered |
---|---|
Author | cprund |
Post date | 2007-07-10T12:45:50Z |
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
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