Taking backup of schema in SAP HANA

It is always recommended to back up your critical systems.

Example

Following SQL command can be used to export schema in HANA:

EXPORT "SOURCE_SCHEMA_NAME".* AS BINARY INTO '/tmp/DESTINATION SCHEMA NAME' WITH
   REPLACE;

This can also be directly zipped to Linux as below:

tar -czf SOURCE_SCHEMA.tgz /tmp/DESTINATION_SCHEMA/

Govinda Sai

Published on 27-Dec-2017 17:25:40

• Related Questions & Answers
• Taking schema wise backup in SAP HANA
• Incremental backup in SAP HANA
• Authoring schema vs Physical schema in SAP HANA
• Use of _SYS_BIC schema in SAP HANA
• Use of _SYS_BI schema in SAP HANA
• Checking backup configuration in SAP HANA
• Using Schema mapping in SAP HANA
• Setting schema mapping in SAP HANA
• Checking list of system schema in SAP HANA
• Changing Ownership of schema in SAP HANA Database
• Checking SAP HANA Schema owner name
• Different schema types in SAP HANA database
• Checking schema creation in SAP HANA database
• Changing authoring schema of catalog objects in SAP HANA
• Checking list of all available schema in SAP HANA