Re: Backup and Restore Help!!!

In article <33C6AC29.411B@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Neal Leitner wrote: >> >> 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. >> >> All help is appreciated!! >> >> Neal Leitner >> WFS Services, Inc. > >You don't say which version of OnLine you have, but v7.xx has utilities, >onarchive or onbar, that allow restore of dbspacesets. By judicious >placement of your tables you could restore a set of tables without >affecting others. > >Could you onunload your database, then reload it elsewhere, THEN export >the tables you want? A bit long-winded, I know. > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK Either a) onunload individual tables b) The better way, use Online DSA 7.2 and OnBar. Does OnBar allows restore of individual tables ? -- David Williams