Re: Backup & Restore Granularity

As Troy Horton wrote OnBar will solve all these problems. Greate. Just some small points: Paul Reimold <preimold@genacc-us.com> wrote: :I am fairly new to Informix admin. I was surprised (and disappointed) to :learn that On-Tape, On-Archive (and, I believe the up-coming On-Bar) :back up and restore only at the dbspace level. WHY NOT AT THE TABLE :LEVEL? : :If a user is in dbaccess, it is frightlenly easy to drop a table. :Indeed, the term 'drop' implies to me that one simply does not want to :work with a table any more, not the more serious action of blowing it :away! But 'drop' is ansi standard and a documented command so it *can't* "imply" anything. It *is* a drop of the whole table. It's of course still very easy to do something unintended with this or other commands in dbaccess (and other tools). :Other than assigning a dbspace to each table, is there any other way to :backup/restore individual tables? In another post ramajig@aol.com (Ramajig) wrote: :Go ahead and use dbexport/dbimport or load/unload. Just be very carefull with the implications from transactions. You might want to open the database in exclusive mode for this, or at least lock the tables involved (if you use unload) so you can be sure your data is consistent. With OnBar there is hopefully functionallity for the same purpose. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org