Skip to Content
0
Former Member
Jun 15, 2009 at 11:39 AM

backup with autolog - strategy for overwrite log files

220 Views

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!