Storm season is back, bringing with it the potential for significant weather events. If you have clients in areas prone to infrastructure disruption, visit the Disaster Recovery Resources guide for preparedness information. Datto recommends performing proactive disaster recovery testing to mitigate potential downtime. See our articles about the importance of disaster recovery testing and Preparing For A Cloud Virtualization Test: Policies, Procedures, And Partner Responsibilities to learn more. For live updates, follow @datto on Twitter.

Backing up SAP HANA Databases: Best-Practices



This article describes best-practices for backing up SAP HANA databases.

What is SAP HANA?

SAP HANA is an in-memory database and application platform. Its primary function as database server is to store and retrieve data as requested by the applications. In addition, it performs advanced analytics (predictive analytics, spatial data processing, text analytics, text search, streaming analytics, graph data processing) and includes ETL capabilities as well as an application server (source).

For more information regarding SAP HANA, see SAP's SAP HANA Backup/Recovery Overview.

On-premise SAP HANA databases are supported by Red Hat Enterprise Linux and SUSE Linux distributions. The Datto solution supports backups of both distributions.

Backup Method

The Datto Linux Agent runs quiescing scripts from /etc/datto/dla/pps/. Since SAP HANA has different syntaxes compared to other RDBMS, such as MySQL, you will need to create a custom script to perform necessary pre- and post-processing. You can use the script to truncate logs as necessary, and perform other tasks.

The quiescing script will need to follow the format of the scripts we provide. You can find these scripts on the production machine in /etc/datto/dla/pps. You will also need to ensure that the script is placed in /etc/datto/dla/pps to be recognized by the Datto appliance. For more information about creating quiescing scripts, see the Agent Configuration - Working with Quiescing Scripts article.

Backup Method

You can perform SAP database and log backups on the Linux host independently of your Datto Linux Agent backups. We recommend saving the database and log backups to a storage volume not included in the Datto Linux Agent's backups to optimize the size of your incremental backups. Datto also recommends scheduling the database and log backups at a separate time from the Linux Agent-based backups to avoid conflicts.

Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Calling all Partners! We want to hear your feedback! Please participate in this quick survey and help us build a better, more-relevant Knowledge Base!

Want to talk about it? Head on over to our Community Forum!