cancel
Showing results for 
Search instead for 
Did you mean: 

Are log backups older than last data backup deleted automatically after the data backup?

0 Kudos

Hi experts,

Are log backups older than last data backup deleted automatically after the data backup?

If not, I wonder if log backups need to be deleted because it would take disk space.
Is there any way to delete old log backups automatically, like using scripts?

Thank you.

Accepted Solutions (0)

Answers (3)

Answers (3)

dennispadia
Active Contributor

Hello Junya,

Log backups are not automatically deleted after data backup. But you can schedule housekeeping script which can help to maintain retention of data backups (for both backup catalog and physical data files).

If you don't want to keep log backup files, you can delete it using below command for files older then x days -

find <logbackupfolder> -type f -mtime +x -exec rm {} \;

You can also schedule housekeeping job as described in your earlier thread

Regards,

Dennis

0 Kudos

Hi Dennis,

We have an SAP HANA Service which is running on AWS to which we don't have OS level Access. Our Instance is quite small only 64GB of Memory. The trace files are piling up and quickly occupying the space on the DB. We would like to know if there is any automated process that can delete the files older than n days?

We have the parameters (Maxfiles, Maxfilessize) present in global.ini. Could you please let me know if there is any other process to delete the trace files that are older than n days? Like a date parameter, which would automatically check the trace file dates and delete the files that are older than 15 days?

former_member182967
Active Contributor
0 Kudos

Refer to note 2399996 - How-To: Configuring automatic SAP HANA Cleanup with SAP HANACleaner, you can use SAP HANACleaner to delete older backups (offline redologs before the last retained full data backup are also removed as well) and catalogs automatically using crontab.

janlars_goedtke
Active Participant
0 Kudos

Hello,

you can use the

BACKUP CATALOG DELETE statement. It has an option to delete the LogFiles on Disc, too.

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/22275913eb9e4a5bb539fc8df3...

It is also implemted in the HANA Cleaner:

https://apps.support.sap.com/sap/support/knowledge/preview/en/2399996

Best regards

Jan