Re: Informix Online Table Recovery: How? -Reply

This little maneuver is called "point-in-time" recovery -- a MAJOR function that should be a part of ANY relational database that allows multiple users. Unfortunately, Informix does not have a "true" point-in-time recovery. You may apply the last backup and all logs except the one that has the "bad" SQL in it. This may mean losing alot of other valuable data. I have been assured that furture releases of Informix will have this (sorry, but had to mention it). I am anxiously waiting!!! Backups and recoveries are a major function of a DBA and one of the reasons we get paid a little more than the average bear. I hope that Informix will try to spend a little R&D money on getting their backups and recoveries working like the other "major" relational databases. (And I am NOT talking about some 3rd party storage manager that you have to purchase separately to tell the operating system how to use its tapes and disks -- hint, hint!) Barbara Garrett Sarasota County