HDBSQL Example: Performing SAP HANA Multitenant SYSTEMDB Database Restores

Restore the SAP HANA SYSTEMDB database.

Before You Begin

1. Perform a SAP HANA full backup on a Multitenant SYSTEMDB database.

2. Stop all tenant databases.

   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.

  HDBSettings.sh recoverSys.py
  

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 each 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]′′