HDBSQL Example: Performing SAP HANA Multitenant Tenant Database Restores with the Data Backup

Restore the SAP HANA tenant database with the data backup.

Before You Begin

1. Perform a SAP HANA complete data backup on a Multitenant Tenant Database.

2. Stop the tenant database. On the command line, type the following command, substituting the tenant_database_name parameter with your value.

    
   hdbsql -U $[user_store_key] “ALTER SYSTEM STOP DATABASE $[tenant_database_name]′′

Procedure

• On the command line, type the following command.

   
  hdbsql -U $[user_store_key] “RECOVER DATA FOR $[tenant_database_name] USING BACKINT ‘$[data_backup]′ CLEAR LOG”

What to Do Next

1. Verify the status of the tenant databases. On the command line, type the following command:

    
   hdbsql -U $[user_store_key] “Select * from M_DATABASES” > $[file_name]

2. View the output file.

3. Start the tenant database. On the command line, type the following command, substituting the tenant_database_name parameter with your value.

    
   hdbsql -U $[user_store_key] “ALTER SYSTEM START DATABASE $[tenant_database_name]′′

Example

Perform a restore

hdbsql -U BACKUPM “RECOVER DATA FOR TEN2 USING BACKINT ‘2015-07-07:09:54:00_COMPLETE_DATA_BACKUP_TEN2′ CLEAR LOG”