Recent hurricane activity has caused major disruptions to the IT infrastructure of many businesses in the Atlantic and Gulf regions. If you are in an impacted area, visit the Disaster Recovery Resources guide for preparedness information. For live updates, follow @dattosupport on Twitter.

Backing up SAP HANA Databases: Best-Practices

Follow

Scope

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.

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