Re: Trying to recover from corrupted db

dejaxes@my-dejanews.com wrote: > > Between tape backups on our development system (SGI-IRIX 6.2), > two things happened: a lot of work was done on the database > ES 3.5.1 w/Informix v7.22) and the disk the database was on got > corrupted. So we're trying desparately to recover whatever we can. > Unfortunately, we don't know the nuts and bolts to be able to do > surgical hacking, only SQL statements and dbaccess. > [Details SNIPPED] > The database from a prior backup tape works fine (tho' as mentioned, > many man-hours went into the database since then). Maybe there's a > way to combine parts of it with what I have now to recover our > database tables? Is your database logging? Did you back up your logical logs to disk or to tape? With these log file backups you can recover to the last completed transaction. You didn't have your logs going to /dev/null did you? Art S. Kagel