RE: Backup and Restore Help!!!

David, ONBAR system doesn't allow backup and restore operation at the table level. But you can backup and restore and the DBSPACE level. If you fragment your table you can backup and restore and the partition level ( That sounds good but it is still at the DBSPACE level). PS: I think ONBAR can resolve the table-level backup problem, IF people stop associating a dbspace with a database. I mean, a dbspace can hold a fragment, a table and a database. Regards, Mario Estrada --------------Reply Separator-------- ---------- From: David Williams[SMTP:djw@smooth1.demon.co.uk] Sent: Friday, July 11, 1997 1:19 PM To: informix-list@rmy.emory.edu Subject: 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