Logical logs backup to disk

Hello Guys, here's another one of which I'm in doubt for some time. Finally decided to post it. If backup of logical logs is written on disk, do you need to rename the existing file first before starting a new backup, or is there an "append" ? In other words, if you don't rename the file after the backup is written, are you overwriting the previous backup ? In this case you probably can't restore because some logfiles may be missing. Thx, Best regards, Jacques Lapeire

Hi, I assume you talk about doing the log backup using the backup utility "ontape" (as opposed to using "onbar"), right? When using "ontape", then indeed it will overwrite the same disk file. There's no append to the file. Therefore if you do not move the content of the file to a safe place before you do the next log backup, it will overwrite and you will have lost the earlier backup of logs. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Christian Diedrich, Matthias Hartmann, Thomas Fell, Christoph Grandpierre, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 ids-bounces@iiug.org wrote on 13.02.2008 13:48:13: > Hello Guys, > > here's another one of which I'm in doubt for some time. > Finally decided to post it. > > If backup of logical logs is written on disk, do you need to rename the > existing file first before starting a new backup, or is there an "append" ? > > In other words, if you don't rename the file after the backup is written, are > you overwriting the previous backup ? > In this case you probably can't restore because some logfiles may bemissing. > > Thx, > > Best regards, > Jacques Lapeire > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!!