Central page of Backup/Recovery topic for SAP Business One, version for SAP HANA

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 SAP Business One, version for SAP HANA 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.

Data backups:

• 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.

2121486 – SAP HANA instance backup ensures data consistency while schema export does not

2134959 – Schema Export and Import Guide for SAP Business One, version for SAP HANA

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.

SAP HANA Backup and Recovery – Technology Troubleshooting Guide – SCN Wiki

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:

  Healing tasks

  Dedicated Heath Checks for SAP HANA

More details could be found.

Remote Support Platform 3.2 – YouTube

Regular System Administration Tasks

Option 2: Scheduling SAP HANA backup with Linux Cron Job.

Schedule backups and set notification mail in SAP Business One, version for SAP HANA (video by Darius)

Backup and Recovery: Scheduling Scripts – blog&video by SAP HANA Academy

http://scn.sap.com/community/business-one/blog/2013/07/24/how-do-i-use-the-cron-to-schedule-a-backup (by Duncan)

1950261 – SAP HANA Database Backup Policy Recommendations and Regular Backup Script (Note from B1)

1651055 – Scheduling SAP HANA Database Backups in Linux

7.How can I backup SAP HANA to external shared file server?

Please refer to this document Backing up your SAP HANA system to external shared file servers

Important SAP Notes:

Notes from SAP Business One, version for SAP HANA:

2157386 – HANA backups scheduling in RSP

2121486 – SAP HANA instance backup ensures data consistency while schema export does not

2134959 – Schema Export and Import Guide for SAP Business One, version for SAP HANA

2151371 – Backup Service cannot handle database passwords containing special characters such as dollar sign ‘$’

2072868 – Backup service for SAP HANA best practices and known limitations

2080821 – Backup service for SAP HANA schemas is available

Notes from SAP HANA:

1642148 – FAQ: SAP HANA Database Backup & Recovery

You are recommended to read this FAQ note for detail.

SAP HANA Backup and Recovery Overview

This document tell you about the mechanism of HANA backup and recovery in depth.

2091951 – Best Practice: SAP HANA Database Backup & Restore