Thank you for your quick and useful response. Is there a way to allow log backups to occur even if the log is unchanged or if less than 1 page gets changed? I think I'll be covered fully with Mirrored Logs and 10 Minute Log backups, differentials and fulls being run daily, but I want to assure I've done everything I can to prevent data loss.
Thanks for your time. Chris Barlow DBA The Nordam Group 918-878-6195 -----Original Message----- From: "Döhr, Markus ICC-H" [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 11:24 AM To: Chris Barlow; 'maxdb@lists.mysql.com' Subject: RE: Log backup sizes > is that if very few changes are made to a system it could take hours > before it actually gets backed up, is this correct? Here's what I'm > thinking and please verify if I'm thinking correctly, with 10 > minute log > backups I have the potential to loose up to 9 minutes and 59 seconds > (roughly due to the time it takes to actually execute the script, then > backup) and/or 7.9k of data? Not hours - but 10 minutes :-) The database writes a checkpoint every 10 minutes and the fact, that this checkpoint has been written will be reflected in an update of a table. This update will produce log. Let's assume you have a problem with the database and you need to recover. In case the logfile (which can be mirrored) is intact it will ask you to recover log and use the yet-not-archived log also to bring the database online to the point it has been before the crash. To ensure maximum security I'd use the mirror log feature on a separate disk. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- 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]
