Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.15 SAP HANA User Guide

Performing backups by using the SAP HANA CLI in an MDC system

You must specify the correct credentials and database name in the hdbsql command to perform a backup of an SAP HANA MDC database.

For a backup of the primary system database SYSTEMDB, you must specify the system database administrator credentials with the hdbsql command.

For a backup of a tenant database, you can specify either the system database administrator credentials or the tenant database administrator credentials with the hdbsql command. However, do not try to use the system database administrator credentials for a direct connection to a tenant database.

NOTE:Use the system database administrator credentials to connect to a target database only through the SYSTEMDB database. Use the tenant database administrator credentials to connect directly to the target database.

For example, the following command backs up the tenant database DB0 by using a connection to the SYSTEMDB database through the system database administrator credentials:

 hdbsql -i 00 -u system_database_administrator_username -p system_database_administrator_password [-U user_key] -d SYSTEMDB "backup data for DB0 using backint ('/usr/sap/SID/SYS/global/hdb/backint/DB_DB0/prefix')"

The following command backs up the tenant database DB0 by using a direct connection to the database through the tenant database administrator credentials:

hdbsql -i 00 -u tenant_database_administrator_username -p tenant_database_administrator_password [-U user_key] -d DB0 "backup data using backint ('/usr/sap/SID/SYS/global/hdb/backint/DB_DB0/prefix')"

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\