how to cancel running data backup in Hana Studio

This blog post provides step-by-step instructions on how to cancel a running data backup in SAP HANA Studio by using HANA Studio SQL Console

Step 1. Open Hana Studio and Login with DATABASE ADMIN user.
Step 2. Open SQL Console (right click on SYSTEMDB)
Step 3. Find Backup ID: – Use the following SQL Statement.

SELECT BACKUP_ID FROM "M_BACKUP_CATALOG"
WHERE ENTRY_TYPE_NAME = 'complete data backup'
AND STATE_NAME = 'running'ORDER BY SYS_START_TIME DESC;
How to Cancel a running data backup of SAP HANA DB?
How to Cancel a running data backup of SAP HANA DB?

Step 4. To cancel the running data backup, use the following SQL Statement
BACKUP CANCEL <backup_ID>

Step 5: – Check that data backup was canceled or not. Use the Monitoring view M_BACKUP_CATALOG for check the status of the canceled data backup.

Example: -Cancel the data backup with ID 1650,396,656,719:

BACKUP CANCEL 1650,396,656,719;
How to Cancel a running data backup of SAP HANA DB?

Leave a Comment