Re: Backing up Informix

At 11:10 AM 5/8/96 -0400, Paul Pathiakis wrote: > I am looking at how to backup an Informix database. I >have issues with regards to how to roll in a transactions >log in the event of a DB crash. I'm sure (I hope) that you >can take the DB offline and perform a dump of the raw disks. >The problem I encounter is restoring this backup in the >event of disaster/failure and being able to take this restored >database state forward to where it crashed. Does anyone have >a procedure for rolling forward with the transaction log? You don't say which engine you're using. This is well documented in TFMs, but in summary: 1. With SE, you back up your DB directory with tar or cpio and also backup the log file. You then simply restore this backup, go into dbaccess/isql and say ROLLFORWARD DATABASE (or ROLLFORWARD LOG, I'm at home and I don't have TFM to hand. :) 2. With OnLine or DSA, you can use tbtape to backup your DB. tbtape -- will give you all the options. You must archive your data and backup your logs. When you restore your archive, the system will ask whether you have any logs to rollforward. 3. With DSA, you have the option of using OnArchive. But it does require a two training course... :-) HTH. Hasta la vista! -- billy.wheeler@pixie.co.za