- 1.What kinds of backup available in SAP HANA?
- 2.Can I perform a backup for a specific schema instead of the whole HANA instance, then rename it for QA?
- 3.Do I have to perform a full data backup(HANA instance backup) regularly?
- 4.How can I perform a backup of my HANA system?
- 5.How can I schedule SAP HANA backup?
- 7.How can I backup SAP HANA to external shared file server?
- Important SAP Notes:
This document collects the documents and videos related to the backup and recovery topic of SAP Business One, version for SAP HANA.
It also compile a list of FAQ of HANA backup and recover from B1H perspective.
1.What kinds of backup available in SAP HANA?
To learn more about insight of SAP HANA Backup and Review, you are recommended to read this document:
SAP HANA Backup and Recovery Overview (Presentation, source of screenshot below)
SAP HANA persists two types of data to storage: transaction redo logs, and data changes in the form of savepoints.
- Full backup (Data and configuration for the whole HANA system instance)
- Delta backup (Available since HANA SP10)
-Incremental backup (based on any latest backup)
-Differential backup (based on the latest full data backup)
Log backups: Automatic unless disabled.
In addition, starting with revision 70 SAP HANA database supports storage snapshots (see SAP Note 2039883).
2.Can I perform a backup for a specific schema instead of the whole HANA instance, then rename it for QA?
SAP HANA does support the export of schema, and import as a different name. However, this operation only export the data and objects(tables, triggers, procedures etc) of schema from database level, which doesn’t assure the data consistency if transaction committed by other connection to the same schema whilst the schema is being exported.
It is recommended to export and import the schema through the SAP Business One Backup Service in SLD or Remote Support Platform. However, if you would like to conduct the schema export and import with SQL by manual, you should follow the note below when export and import schema.
All you need to know about SAP Business One, version for SAP HANA Schema Export and Import (Check this blog for the appropriate keywords for SAP Business One company schema export and import by manual.)
Doing a schema backup is not the same as a full system backup. A full system backup is still required, see question 3 for more information.
3.Do I have to perform a full data backup(HANA instance backup) regularly?
Yes, like any DBMS, full data backups of the whole HANA instance should be performed regularly for disaster recovery.
After a full data backup, the log backups before the latest full data backup can be checked for consistency, then deleted safely if no recovery to the earlier stage required.
Without regular full data backup and deleting older log backup, the log backup may keep growing up to full disk, which may result in outage of SAP HANA system.
4.How can I perform a backup of my HANA system?
Option 1: (Recommended) perform an SAP HANA instance backup with RSP. Please refer to 5.How can I schedule SAP HANA backups?
Option 2: You can manually perform a backup with SAP HANA studio, or SQL command.
5.How can I schedule SAP HANA backup?
Option 1: (Recommended) Scheduling HANA backup with RSP
This is the first option for SAP Business One partner and customers to automate the backup and house keep tasks.
Since B1H 9.1 PL07, the following scheduling functions are available in RSP 3.1 PL07 with graphical user interface.
-HANA instance backup
-Schema export: select a specific schema to be exported regular.
-House keeping to delete older data backup and log backup. You can setup the retention size of data and log backup. RSP will help to deleter the older backup in a safe way.
Please refer to note 2157386 – HANA backups scheduling in RSP
Note that following new features are delivered in RSP 3.2 for SAP Business One, version for SAP HANA:
Dedicated Heath Checks for SAP HANA
More details could be found.
Option 2: Scheduling SAP HANA backup with Linux Cron Job.
Backup and Recovery: Scheduling Scripts – blog&video by SAP HANA Academy
7.How can I backup SAP HANA to external shared file server?
Please refer to this document.
Important SAP Notes:
Notes from SAP Business One, version for SAP HANA:
Notes from SAP HANA:
You are recommended to read this FAQ note for detail.
This document tell you about the mechanism of HANA backup and recovery in depth.