Use the following command to find and list the HANA database data and log failed backups.
SELECT C.BACKUP_ID, c.ENTRY_TYPE_NAME AS BACKUP_TYPE, C.SYS_START_TIME, C.SYS_END_TIME AS SYS_STOP_TIME, C.STATE_NAME AS STATE, C.MESSAGE AS ADDITIONAL_INFORMATION, F.SERVICE_TYPE_NAME AS SERVICE, F.SOURCE_ID, F.SOURCE_TYPE_NAME AS SOURCE_TYPE, F.DESTINATION_PATH FROM SYS.M_BACKUP_CATALOG C, SYS.M_BACKUP_CATALOG_FILES F WHERE C.ENTRY_ID = F.ENTRY_ID AND (C.STATE_NAME = 'failed' OR C.STATE_NAME = 'canceled' ) ORDER BY C.BACKUP_ID DESC
The output will shows some important information which are the backup type, start and stop time, additional information on failed backups and the destination path.
