Hana studio log backup files

[former_member622718]

HI All,

i am deleting log backup files from hana studio but at os level still log backup files are showing all.

Log backup file are not deleting

[soham1594]

Hello Manoj,

In order to delete log backup files from OS level, please refer below steps.

1. Check log backup file:

Execute below sql command to check the log backup files. (Check for SystemDB and TenantDB separately.)

select t1.entry_type_name, t1.backup_id,t1.state_name, to_varchar(t1.sys_start_time,'YYYY/MM/DD') as sys_start_time, t2.SOURCE_TYPE_NAME, t2.SERVICE_TYPE_NAME,t2.BACKUP_SIZE,t2.DESTINATION_PATH,t2.DESTINATION_TYPE_NAME from "SYS"."M_BACKUP_CATALOG" t1, M_BACKUP_CATALOG_FILES t2 where t1.backup_id = t2.backup_id and t1.entry_type_name = "log backup"

2. Copy BACKUP_ID up to which you want to remove log backup files.

3. Purge log backups:

Execute below sql command to purge log backups. This will remove all backups present older then BACKUP_ID from backup catalog and OS level. (Execute from SystemDB and TenantDB separately.)

BACKUP CATALOG DELETE ALL BEFORE BACKUP_ID <BACKUP_ID> COMPLETE;

Moreover, if you do not want log backups to be generated then you can modify parameter log_mode to overwrite from normal.

Hope this justifies your question. Let me know in case of any queries.