How to delete differential and Log data backup daily and keep Full data backup in HANA Cockpit

[yo_muhammad]

Hello Everyone!

We have configured three types of scheduled data backups for our all SAP Systems. On the 1st of every month, we have our Full Data Backup, every morning at 6 am we have our Differential Data Backup, and after every 30 minutes, we have our log backup.

Till now we use to delete differential and log data backups manually on regular basis to maintain disk space, while we keep Full data backup for a complete month. Now we want to configure the Retention Policy in HANA Cockpit to automatically delete Catalogs and Physical files from our backint location.

The problem we are facing is that the Retention policy deletes the complete old set of Data backups (Full, differential, log), what we exactly want is that our full backup should stay for a complete month and our old differential and log backups should only be deleted on a daily basis so that our storage space doesn't get exhausted.

Is there any way to configure a retention policy like that??

[Neeraj_Jain]

Hello yo_muhammad,

Please refer below SAP Note and Blog. Might be it's helpful to you.

https://userapps.support.sap.com/sap/support/knowledge/en/2950547

2950547 - How-To: Delete old data backup and log backup automatically

https://blogs.sap.com/2020/07/31/cleanup-of-backup-catalog-using-retention-policy-in-hana-db-2.0-usi...

Confirm if it's works for you.

Regards,

Neeraj Jain

[yo_muhammad]

Hello Neeraj,

Thanks for sharing this, but I have already seen it and I know how to configure the retention policy. My question is will it delete old differential and log files on daily basis? For instance if we have set keep backup for 30 days, and we have new scheduled differential backup for today, will it delete old differential backup of yesterday or will it keep all differential backups for 30 days along with full data backup?