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')"
Data is not available for the Topic
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: <>()\