RE: Logical Log Backups.

--openmail-part-01a70b72-00000001 Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" Content-Disposition: inline; filename="BDY.TXT" Content-Transfer-Encoding: 7bit Hi, What happens is the database engine hangs until the tape gets changed. We have had that happen a number of times where we forgot to change the log tape in time. After changing the tape the logs will write to the new tape and the engine will free itself. Another option is to change the tape device to /dev/null. This will cause the log files to be lost though. If you take this option you should do a level 0 immediately following. Regards, Tim Hope Why are there flotation devices under plane seats instead of parachutes? -----Original Message----- From: tim [SMTP:tim@blackbird.net] Sent: Monday, November 23, 1998 6:11 PM To: informix-list Cc: tim Subject: Logical Log Backups. I'm having trouble finding a solution to a rather simple question. If you are backing up logical logs to tape, what happens when the tape fills up? Obviously you would not want to write over transactions. Do you need to guess how fast the tape will fill up and swap them out once in a while? If a archive is made I understand that the logical logs before the archive are not necessary to restore, but what happens if the tape fills up before an archive occurs? Thanks for any advice, Tim --openmail-part-01a70b72-00000001--