You can check the SAP HANA backup Destination Path, Backup Size, Destination Type etc. informations via below SQL script.
SELECT BACKUP_ID, EXTERNAL_BACKUP_ID, HOST, DESTINATION_PATH, BACKUP_SIZE, DESTINATION_TYPE_NAME
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);
Example output of a SAP HANA database ;
Also we can check these informations from “SAP HANA Studio”
M_BACKUP_CATALOG_FILES view structure like below ;