SAP HANA – How to cancel a running backup

To cancel a running backup, please use the following 3 SQL statements:

  1. Get the backup_id of your running backup:
    select BACKUP_ID from “SYS”.”M_BACKUP_CATALOG” where entry_type_name = ‘complete data backup’ and state_name = ‘running’  order by sys_start_time desc
  2. Cancel the backup
    backup cancel <backup_id>
  3. Confirm the backup has cancelled
    select state_name from “SYS”.”M_BACKUP_CATALOG” where backup_id = <backup_id>
  4. Check to  make sure there are no running backups still
    select * from  “SYS”.”M_BACKUP_CATALOG” where STATE_NAME = ‘running’;
  5. If the backup still exists, you can try to cancel the thread through the commands:
    ALTER SYSTEM CANCEL SESSION ;
    ALTER SYSTEM DISCONNECT SESSION ;

2 Comments

  1. Sunil November 4, 2016
  2. SAP HANA WIKI November 4, 2016

Leave a Reply