Deleting Backups Using SAP HANA Tools
To configure retention policies for SAP HANA backups, you can use the SAP HANA housekeeping options:
- Manual Deletion of Backups in SAP HANA Studio
- Configuring Retention Policy in SAP HANA Cockpit
- Deletion of Catalog and Backups Using Scripts
If you delete backups from a backup catalog using scripts or SAP HANA Studio and don't select the option to delete backup physically from the backup location, backups will remain in the backup repository. In this case, we recommend to enable the options for physical deletion of backups in used SAP HANA retention tools or you must enable the force deletion feature of Veeam Plug-in for SAP HANA. Otherwise, you will run out of space on the backup repository.
For details, see the Housekeeping for Backup Catalog and Backup Storage section of the SAP HANA Administration Guide.
To physically delete the backups, you must select the Catalog and Backup Location option. Note that if you have physical backups in both the file system and a Veeam backup repository, you can choose to delete data backups in only one location.
For details, see the Retention Policy section of the SAP HANA Administration with SAP HANA Cockpit Guide. Note that the retention policy functionality is supported only in SAP HANA 2.0 SPS03 and later versions.
When you configure a retention policy in SAP HANA Cockpit, make sure that you have selected the Also delete physically from Backint check box in the Options for Backup Deletion section. Otherwise the backups will not be deleted from the repository.
Deletion of catalog and backups using scripts. For details see the BACKUP CATALOG DELETE Statement section of the SAP HANA SQL and Views Reference.
To physically delete backups from the backup repository, you must include the WITH BACKINT and WITH FILE options in the script.