Re: Backup DB ontape, fgl_xxx list and sqlcmd From Sam Leffler.

Christian Hernoux wrote: > > Q1 : > ==== > In a dbspace I have 3 databases. > When I backup a dbspace, I save these databases. > If I have a problem on a database is it possible to backup this database and > restore it ? > (dbunload or dbexport on tape drive ? some examples ?) > I work with Informix ON-Line 5.01 on SCO with a 2GB tape drive. > I sometimes use dbexport (to disk or tape) for this purpose (e.g. to backup daily version of a small database containing some critical configuration parameters for a large application). However, this method is rather slow (especially dbimport part - all those index and constraint builds...) Also beware of this: dbexport wants exclusive use of a database; in V5 it does not conserve extent sizes, table placement (regarding dbspaces) and table lock level; it does not work with tapes larger than 2GB (at least on AIX - the size "wraps over"). If your backup is just protective one (i.e. you will only use it if disk crashes or somebody drops the database - yes, I have seen it happen :-), back up dayly, do continuous backup of logs to tape, and, if something happens, simply restore everything. Regards, Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+