Re: Backup and Restore Help!!!

Some salient issues for this debate: 1. onunload/onload do not support fragmented tables. 2. Why do you want to restore individual tables? If using OnBar (with 1 table per dbspace) then be aware that: a) you can only restore dbspaces that are 'down' (i.e. you cannot arbitrarily decide to restore a dbspace). b) if you are performing a selective restore as opposed to a full system restore, you *must* rollforward your logs, thereby arriving back at the situation you were in before the decision to restore. 3. Would the High Performance Loader be an option (will need exclusive access to the tables being unloaded to ensure that the data is consistent). Chris > From: Neal Leitner[SMTP:leitner@worldnet.att.net] > Sent: Thursday, July 10, 1997 4:32 PM > To: informix-list@rmy.emory.edu > Subject: Backup and Restore Help!!! > > I have a problem, which I thought was a simple one to fix, but after > consulting with Informix, there is no current Informix utility to solve > my problem. > > My problem is: I want to backup my On-Line database each night to tape > and be able to selectively restore tables if needed. Ontape does a good > job of backing up the whole database and restoring individual database > spaces, but I don't want to have to restore the entire space, just a > table or two within that space. > > I thought about a dbexport, but my users complained each night when I > kicked them off the system since dbexport requires exclusive access to > each of the tables. > > Does anyone have any ideas or experience with my problem. -- ------------------------------------------------------------ Chris Jenkins, Advanced Technology Group, Informix Software Standard disclaimers apply