Re: Informix OnLine backup alternative ?

chmae@guug.de (Christoph Maethner) writes: >ssjen@iphase.com (Shen Shane Jen) writes: >>Is there any backup system out there that will backup the raw disk partition >>and also preserve the database's integrity at the same time ? >>Although I'm pessimistic about this, but any information is appreciated, >If you need the database for quick access more than for *lots * of data >(like I do) consider the following. >Every day before backuptime you run (by cron) a dbexport on all the databases >and compress the resulting data. After backup you can delete the compressed >data. This solution implies enough free space on your disks. >I am sure, there is a more elegant solution - but for a quick and >dirty approach it certainly worked for me :^) >Chris Dbexport requires that there are no sqlturbos running while doing the export. There are some theoretical solutions to do a backup like dump or dd if=rawdevice, but none of them preserves the integrity of the database. So I'am afraid there is no solution but tbtape. -- ------------------------------------------------------------------------------ fighting for peace is like fucking for virginity (stolen from L.Peter Deutsch, but the signature is too good,isnt't it) ------------------------------------------------------------------------------