This article describes best-practices for backing up SAP HANA databases.
- Datto SIRIS
- Datto ALTO
- Datto Linux Agent
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.
Datto Linux Agent
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.
SAP database and log backups
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.