Re: Restoring to point in time

Hayward, This is exactly the problem I chatted about a while back regarding point in time restores. If enough people actually had to restore from their backups they would demand Informix change the way the restore operation works. Unless you put each database in a separate instance you will have no choice but to restore the whole dang instance which will restore any and all data bases in that instance. :-) Best wishes to you... Tim PS The bullet-proof Informix backup is still a backup to disk via table unloads and then spinning the unloads off to another medium. This is guaranteed to work and allows you to incrementally restore tables at your leisure. "Hayward, Kevin" wrote: > > I am using Informix 7.3 TC8 on Windows NT 4 SP4. I use Legato Networker > to do unattended backups of my Dbspaces. I have one server that has one > instance of Informix with 12 different databases. Each database has a > Dbspace for data and a Dbspace for indexes. I would like to restore > only one of these databases back to June 23 at 3:30 p.m.. All of the > other databases I would like to have current. The only thing that I can > think of doing is the following: > > 1) Restore the whole instance back to June 23. > 2) Export the database that I want at this time. > 3) Restore the whole instance back to the current time. > 4) Drop the database in question. > 5) Import the database in question. > > I figure that this will take me approximately 14 hours to pull this off. > Does anyone else have any other ideas how I can get just this one > database back to the June 23 time frame with out taking the whole > instance back in time? > > Kevin Hayward > hayward_ke@leg.wa.gov -- - -- --- Tim Schaefer ---- tschaefe@mindspring.com --- http://www.inxutil.com -- -