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 this SAP article.
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 this SAP article.
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'); |