Backup strategy

Environment: SCO Unix 5, Informix IDS 7.30UC2 WE 4GL RDS 7.20.UD7 I have a rather small Database: ~150 tables, ~3-4GB of data. For backup reasons we use ontape -s (in a DAT). Some times I need to restore data from a single table. Cause I don't know if this is possible (and simple and secure ..) with the "ontape" cartridges, I use to extract the night the whole DB with "dbexport" in a separate partition. I know this is not quite safe but sometimes it was very useful. Any suggestions welcome Pantelis Magos

Hi there what about onunload and onload? its fast but has its difficulties (e.g. platform-dependency) dbexport is the easiest, cleanest and most portable way. I'd rather stick with this method hope it helps