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