Use the SQL console for the database instance the prepared snapshot has been created for and run the query:
“SELECT BACKUP_ID, COMMENT FROM M_BACKUP_CATALOG WHERE ENTRY_TYPE_NAME = 'data snapshot' AND STATE_NAME = 'prepared'”
This will return the backup ID for the prepared snapshot, which is used in the FlashArray block device snapshot creation as a suffix to link the SAP HANA storage snapshot ID to the Volume snapshot.
|
In SAP HANA Studio right click on the instance and select “Open SQL Console”. |
|
|
|
In SAP HANA Studio execute the query to return the Backup_ID of the prepared database snapshot. |
SELECT BACKUP_ID, COMMENT FROM M_BACKUP_CATALOG
WHERE ENTRY_TYPE_NAME = 'data snapshot'
AND STATE_NAME = 'prepared' |
The Backup ID is returned with any comments added to the entry, take note of the Backup_ID. |
|
|