Re: Backup & Restore Granularity

jlumbley@netcom.com (Joe Lumbley) wrote: :Matt Bentley (mbentley@xmission.com) wrote: :: In article <32E8C9E4.167E@genacc-us.com>, :: 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? :: > : :Table level backups would be nice, but it could create problems with database :integrity. Suppose you had two tables that relate to each other. If you :restore one and not the other (at the same time), your data would be out of :sync and it would wreck havoc with a relational model. Actually I'm :surprised that Informix lets us do dbspace level backups. One of my :loves/hates with Informix is that the products are very paternalistic... :they don't let you do things that will compromise your relational model, :even if you know what you're doing and you really do want to compromise it. Yes indeed. It would be more than nice to have a table level restore function to the regular ontape and soon onbar backup systems. Sometimes a compromised database is better than no data and a complete restore may simply not be an option. Often I even *know* that a table level restore will *not* result in a compromised database. I am at a loss to understand why it isn't implemented in OnLine. (It is simple with SE of course.) It would have made life simpler, and shouldn't be too hard to do. Or may be it is? 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