Hi nerec79, If log overwrite is ON, you should be able to restore any complete and incremental data backups, as long as the resulting state of the data volumes matches the current information available on the log volume.
If you switch off log overwrite and use autolog or manual log backups you can of corse delete any useless log backups. They are just files in the file system. There is no best compromise for log configuration, if HD space is the criteria. You could use the available space for one log volume plus log overwrite or you could configure a very small log volume and use the rest of the available space for log backups or something in between. Best regards, Tilo Heinrich SAP Labs Berlin >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Wednesday, December 15, 2004 5:56 PM >To: maxdb >Subject: SapDB recovery > > >Hi all, >i have some questions about recovering sapDB. >If i have the log overwrite ON, the only recovery that i can >perform is restoring the last data backup? >If i change the parameters, setting off the log overwrite and >setting autolog on, is it possible to delete the old unusefull >autosave backup files? >What is the best compromise between occupied spaced on HD and >recovery police? That is to say the best data and log >configuration without taking a lot of HD space? > >Thanks all for help! > > > >____________________________________________________________ >Regala e regalati Libero ADSL: 3 mesi gratis, navighi veloce e >scarichi a 1.2 Mega. >Abbonati subito senza costi di attivazione su http://www.libero.it > > > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
