Re: Best backup scheme of single tape drive system

Joseph, You could do the continuous backup to Disk. This is not recommended by Informix because of potential hard disk failure problems ie: if you have a major crash and the logical log is corrupted as well as the database you can only recover to the last backup. David Ashby ______________________________ Reply Separator _________________________________ Subject: Best backup scheme of single tape drive system Author: "Chuanlarp Satchavarodom" <chuanlarp@bigfoot.com> at WCA-INET Date: 30/6/98 3:23 PM Dear List, I have a question about continuous database backup for a single tape system. I want to do continuous logical log back up, but my system has only one tape drive. If I dedicate it to back up full log file, when I want to do dbspace backup, I am gonna have a problem. This is what I plan to do, I will set a logical log backup to tape, and when the schedule time for dbspace backup arrives, I will stop the continuous log back up. Backup dbspace and perform automatic logical log backup and turn on the continuous log again. Does this make sense? Is there a way to better automate the whole thing with single tape system? Thank you Joseph Chuanlarp Satchavarodom chuanlarp@bigfoot.com Software Developer .