You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation.

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;

Query to list backup catalog ;

select * from M_BACKUP_CATALOG;

Check to  make sure there are no running backups still ;

select * from  “SYS”.”M_BACKUP_CATALOG” where STATE_NAME = ‘running’;

Estimated backup size ;

SELECT SUM(allocated_page_size) FROM M_CONVERTER_STATISTICS;

Show latest backup file names for a recovery ;

SELECT DESTINATION_PATH 
FROM M_BACKUP_CATALOG_FILES 
WHERE BACKUP_ID >= (SELECT TOP 1 BACKUP_ID FROM M_BACKUP_CATALOG 
WHERE STATE_NAME = ‘successful’ 
AND ENTRY_TYPE_NAME = ‘complete data backup’ 
ORDER BY UTC_START_TIME desc) ;