Skip to Content
avatar image
Former Member

backup with autolog - strategy for overwrite log files

Hello together,

i 've a question regarding the backup strategy of my SAP DB. I created some backup media to do a full, incremental and log backup, activated autolog and all went fine.

For complete and incremental backup media, I enabled the overwrite flag, so I have one file containing the complete backup of a week and four files containing the incremental backups of each weekday.

Now I faced the problem that the autologs are always added because the autolog media is not enabled for overwrite.

My question is: What is the best strategy to "save" disc space without manually deleting older autolog files?

Should I enable overwrite for autolog as well? What does this mean in case of restoring the database?

Any help and hints are welcome!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 15, 2009 at 12:38 PM

    Hi,

    well... using the overwrite option of both the incremental and full backup media (called backup templates from version 7.7 onwards) in your case means that you can go back one week at max during a recovery. You must decide for yourself if that's okay for your business.

    If you specified the incremental backup to overwrite itself, howcome you have 4 of them at the end of the week? I'd say you'd have one.

    Another thing to consider is that you'd really not have much alternatives in case your backups are unusable, for example due to hardware issues.

    There is no option to overwrite existing logbackups, as you've probably noticed they're written sequentially, one after the other (example: LOG.001 is followed by LOG.002).

    Regards,

    Roland

    Add comment
    10|10000 characters needed characters exceeded

    • Hiho,

      I stated that you needed all the logbackups from after your full data backup, but those created after the last incremental would technically suffice, BUT the big pluspoint would be that you'd have an alternative recovery strategy (fulldatalogs & fulldatainc+logs), that's why I recommended it. Please excuse me for not being clear enough on this point.

      Regarding the father-grandfather principle: you save (i.e. 'archive') your backups also to tape?

      We've also got options to manually or automatically (using SAP CCMS and third pary tools) archive log backups. You can find out more on this subject in our online [documentation|http://maxdb.sap.com/doc/7_7/44/d97af17a012754e10000000a1553f6/content.htm].

      Regards,

      Roland