SAP Hana How to Cancel Running Backup

Here , I Explained about how to cancel the running backup ,check data backup status,check log backup status and backup related SQL queries with SQL Command Detail.

Hana Query to find Backup id of running data 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

Monitoring View for Backups:

M_BACKUP_CATALOG

Hana Query to cancel running backup?

backup cancel  (backup_id)

Hana query to check the state of the data backup?

select state_name from "SYS"."M_BACKUP_CATALOG" where backup_id = (backup_id)

Check to  make sure there are no running backups still:

select * from  "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';

Hana query to find older service specific log backups?

select destination_path from m_backup_catalog_files d where d.last_redo_log_position is not null and exists (select 1 from m_backup_catalog_files k where k.backup_id=(backup_id)  and k.source_id=d.source_id and k.redo_log_position>d.redo_log_position) order by destination_path

Backup Related SQL queries -
 
SELECT (TOTAL_READ_SIZE+TOTAL_WRITE_SIZE)/TOTAL_IO_TIME,* FROM M_VOLUME_IO_STATISTICS WHERE TOTAL_IO_TIME > 0
 
SELECT TOTAL_READ_SIZE/TOTAL_READ_TIME, * FROM M_VOLUME_IO_STATISTICS WHERE TOTAL_READ_TIME > 0
 
SELECT  TOTAL_WRITE_SIZE/TOTAL_WRITE_TIME, * FROM M_VOLUME_IO_STATISTICS WHERE  TOTAL_WRITE_TIME > 0
 
SELECT HOST, PORT, VOLUME_ID, PAGE_SIZECLASS, SUPERBLOCK_COUNT, FILL_RATIO, USED_BLOCK_COUNT FROM M_DATA_VOLUME_PAGE_STATISTIC

Note - In case of a recovery issue the following SQL query result is important too -

SELECT * FROM SYS.M_DEV_RECOVERY

Please note that this system view is designed for internal purpose. SAP doesn't guarantee that this view will be available in the future.