Hello Joerg, If you use MaxDB 7.5.00.40, 7.6.02.00 or newer versions of 7.5 and 7.6 you can specify an interval while starting the automatic log backup, e.g.:
dbmcli -d ... -u ...,... -uUTL -c autolog_on <medium_name> INTERVAL 3600 This would ensure, that the backup of a log entry is started at least 3600 seconds after the log entry was written onto the log volumes. The interval option does not ensure log backups to fixed points in time but sets a time limit to the log entries lost, if the log volume is lost. Best regards, Tilo Heinrich Senior Developer MaxDB&liveCache SAP AG http://www.sap.com <http://www.sap.com/> Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 17. Juli 2007 14:18 To: maxdb@lists.mysql.com Subject: more AUTOLOG Hello, how can i have AUTOLOG every hour, without AUTOLOG OFF and backup? Sorry but will not resize the LOG area. The LOG area will be a standard on our systems. :-( Kind regard Joerg -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]