How To find the backup ID of the running data backup in hana

Step 1. Login to SAP HANA Server

First we need to connect to SAP HANA server using Linux clients (eg: putty) with root user.

Step 2. Switch to SAPHANA Admin User

Now we need to switch to SAP HANA admin user using following command.

su -sidadm

Step 3.Connect to Database instance

Now connect to SAP HANA database instance using following command. For below command you required sap hana server name and database instanace number and password for SYSTEM account.
hdbsql -i <instance number> -u <user> -p <password>

Step 4. use the following SQL command to find Backup id

After successfully connecting to SAP HANA database instance, run below sql command

hdbsql HDB=>select BACKUP_ID from “M_BACKUP_CATALOG” where entry_type_name = ‘complete data backup’ and state_name = ‘running’ order by sys_start_time desc;

Leave a Reply