Backup & Restore Granularity
Posted in 1997
Paul Reimold — — source: Informix-list mailing list archive (1991-1998)
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!
Other than assigning a dbspace to each table, is there any other way to
backup/restore individual tables?
--
** Paul J. Reimold UNIX Administrator **
** General Accident Insurance **
** 436 Walnut Street Phila, PA 19106 **
** (215) 625-2146/625-4350 (fax)/preimold@genacc-us.com **