Hello Michael, >Currently we are backing up every hour. >Due to a type of failure we had recently where memory in our db server >failed and DELETED some database config files and some data >files I do all >backups for MIGRATION.
If your database version is 7.4 or above, there is no difference between backups for recovery and backups for migration. Backups do not contain any configuration data except the database parameters >Currently I am backing up complete once per night, and >incremental every >hour, but not the log ( although autolog is on of course ). > > >I was backing up the log every hour too, however as I don't >need the log to >get my data back from a migration backup, and it created so many files >I decided I would just leave it autolog backup. If you backup log every hour you should get at maximum 24 log backups more, as if using autolog backup. >Would this be considered to be a perfectly good way to do my >backups, or >would it be better if I also backed up the logs each night >along with the >migration data backup? That depends of course on your backup aims. Log backups are usually needed, if as much data must be restored as possible after a failure of the drive containing the log volume. They also are useful if a needed data backup turns out to be on defect storage media and a previous data backup is still available. Best Regards, Tilo Heinrich SAP Labs Berlin > >regards >Michael Andrewes - Software Director >C O M M U N I C A T O R Interactive Marketing > >P +612 9719 1469 F +612 9719 1796 M +61 410 677 458 PAGER >+612 9214 8752 >W www.communicator.com.au >Copyright Communicator Interactive Marketing Pty Limited 2004 > >CONFIDENTIAL INFORMATION owned exclusively by Communicator Interactive >Marketing Pty Limited. The information in this email and any >attachments is >privileged and confidential, intended only for the use of the >recipient or >the intended recipient. If you are not the intended recipient, >any use of >the information is strictly prohibited. If you have received this >communication in error, please inform us immediately and >delete the message >and any attachments > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
