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.
- Differential backup of a tenant database.
- Incremental backup of a tenant database.
- 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.
- Full backup of SYSTEMDB.
- Differential backup of SYSTEMDB.
- Incremental backup of SYSTEMDB.