Backing up SAP HANA data

You can define backup jobs to protect your SAP HANA data. To regularly back up your data, define a backup job that includes a service level agreement (SLA) policy.

Before you begin

During the initial backup operation, IBM Spectrum® Protect Plus creates a vSnap volume and Network Files System (NFS) share. During incremental backups, the previously created volume is reused. The IBM Spectrum Protect Plus SAP HANA agent mounts the share on the SAP HANA server where the backup is completed.

Review the following prerequisites before you create a backup job definition:

Add the application servers that you want to back up. For the procedure, see Adding an SAP HANA application server.
Configure an SLA Policy. For the procedure, see Defining a Service Level Agreement backup job.
Before an IBM Spectrum Protect Plus user can set up backup and restore operations, roles and resource groups must be assigned to the user. Grant users access to resources, and backup and restore operations, in the Accounts pane. For more information, see Managing user access.
Make sure that you have the required privileges to protect the resources. Run the following command in SAP HANA hdbsql utility to grant the required privileges:
```
create user sppadmin password MyPassw0rd no force_first_password_change

grant backup admin, catalog read, inifile admin, database recovery operator to sppadmin
```
where sppadmin specifies the username, MyPassw0rd specifies the password, and backup admin, catalog read, inifile admin, database recovery operator are the required privileges.
Point in time recovery is not supported when one or more tenant databases or SAP HANA services are added to the database instance in the period between the chosen point in time and the time that the preceding backup job ran.

Restriction: Do not run inventory jobs at the same time when backup jobs are scheduled.

Procedure

In the navigation panel, expand Manage Protection > Databases > SAP HANA.
Select the check box for the instance that you want to back up.

Under each SAP HANA instance, data to be backed up is listed as ALL (SYSTEMDB + x tenants) where SYSTEMDB represents the system database and x represents the number of tenant databases. Each instance in the Instances pane is listed by instance name, version, and the applied SLA policy.
Click Select Options to enable or disable log backup, and to specify parallel streams to minimize the time taken for large data movement in the backup operation.
Enable Log Backup

Select this check box to back up archive logs, which allows point in time restore options and recovery options. For SAP HANA log backup settings information, see Log backups.

Maximum Parallel Streams per Database
Enter a number of parallel streams, and then click Save.
Tips for configuring the option:
Review the following tips to help you configure the option for the backup job:

To set the option for child resources to the same value as the parent, click Set all options to inherit.

If multiple resources were selected for the backup job, the option value is indeterminate. If you change a value for the option, that value is used for all selected resources after you click Save.

If an option value is changed from the previously saved value, the option is shown in yellow.

To close the Options pane without saving changes, click Select Options.
The saved options are used for all backup jobs for this instance as selected.
To run the backup job with these options, click the instance name, select ALL (SYSTEMDB + x tenants) database representation, and click Run.
The backup job begins, and you can view the details in Jobs and Operations > Running Jobs.
Tip: The Run button is only enabled if an SLA policy is applied to the ALL (SYSTEMDB + x tenants) representation of the databases.
To run an on-demand backup job for multiple databases that are associated with an SLA policy, click Create job, select Ad hoc backup, and follow the instructions in Running an ad hoc backup job.

What to do next

Important: If the backup operation fails with an error, follow the procedure described in Troubleshooting failed backup operations for large Db2, MongoDB, and SAP HANA databases.