This is an archive version of the document. To get the most up-to-date information, see the current version.

Backing Up Databases Using SQL Commands or Scripts

You can use HDBSQL to backup and restore SAP HANA databases using Backint. For details on the HDBSQL backup, see the BACKUP DATA Statement section of the SAP HANA SQL and System Views Reference.

The following example shows how to configure secure storage of SAP HANA connection data and provides a list of options for the SAP HANA database backup process.

Prerequisites

Before the backup process, you can use the HDBUSERSTORE tool to set secure storage of SAP HANA connection details.

Log in to SAP HANA HDBSQL as the operating system administrator (<sid>adm) run the following commands. For details, see the Secure User Store section of the SAP HANA Security Guide.

sh4adm@linux-q0pn:/usr/sap/SH4/HDB01> hdbuserstore SET <key> hostname:30013@SID <username> <password>

sh4adm@linux-q0pn:/usr/sap/SH4/HDB01> hdbsql -U <key>

Backing Up SAP HANA Databases Using Backint

To back up the database with Backint, use one of the following commands depending on which type of backup you want to perform:

Full backup of SYSTEMDB

backup data using backint ('backup_name_prefix');

Differential backup of SYSTEMDB

backup data differential using backint ('backup_name_prefix');

Incremental backup of SYSTEMDB

backup data incremental using backint ('backup_name_prefix');

Full backup of a tenant database

backup data for <TENANT_DATABASE_NAME> using backint ('backup_name_prefix');

Differential backup of a tenant database

backup data differential for <TENANT_DATABASE_NAME> using backint ('backup_name_prefix');

Incremental backup of a tenant database

backup data incremental for <TENANT_DATABASE_NAME> using backint ('backup_name_prefix');

Full backup of a tenant database with the ASYNCHRONOUS option. The ASYNCHRONOUS option can be helpful if you monitor SAP HANA backups on another host and just want to run the backup command from a script. The option runs the backup job in the background and closes the current script session.

backup data for <TENANT_DATABASE_NAME> using backint ('backup_name_prefix') ASYNCHRONOUS;