SAP HANA Plugin | Delete old backups

[dcampregher]

Hi!
A customer is facing a issue with with the deletion of old backup from backup repository.
They are trying to run this command to remove specific backups for free space but none files are removed from repository:

BACKUP CATALOG DELETE BACKUP_ID 1617588201350 COMPLETE;

If they try to run this other command, a sintaxe error happen:

BACKUP CATALOG DELETE BACKUP_ID 1617674589735 WITH BACKINT;
Could not execute 'BACKUP CATALOG DELETE BACKUP_ID 1617674589735 WITH BACKINT'
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "WITH": line 1 col 47 (at pos 47)


Case 04795280. Any idea for what could be verified ?

[PetrM]

Hi Diogo,

According to the error message, there is a problem with SQL statement. It's difficult to say what exactly is wrong, a query seems to be fine at first sight. I believe the best action plan is to wait for reply from our support team.

You may check this page and perhaps it would make sense to try deletion via SAP HANA studio, at least to check whether it works or not, for example according to this instruction. By the way, you should also include WITH FILE in script, please refer to this page on our help center to get more information regarding different tools. Also, there is an option to enable force deletion of old backup files, however it's better to use this option to delete files which are no longer in HANA catalog.

Thanks!