Loading...

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

Last modified: 7/10/2018 2:34:05 PM