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;
Step 4. To cancel the running data backup, use the following SQL StatementBACKUP 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;