HANA Backup Filename, Destination and Size Informations

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 ;

HANA Backup Filename Destination and Size Informations

Also we can check these informations from “SAP HANA Studio”

HANA Backup Filename Destination and Size Informations

M_BACKUP_CATALOG_FILES view structure like below ;

HANA Backup Filename Destination and Size Informations

 

 

 

Leave a Reply


7 × one =

Blogroll