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

Database Backup (HDBSQL Scripts)

After you configure Veeam Plug-in settings, you can use HDBSQL to back up and restore SAP HANA databases. For details on the HDBSQL backup, see the BACKUP DATA Statement section of the SAP HANA SQL and System Views Reference.

Prerequisites

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

To configure hdbuserstore, you must log in to SAP HANA HDBSQL as the operating system administrator (<sid>adm) and 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 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;

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');