Home > Workload Solutions > SAP > Archive > SC Series Storage Configuration Best Practices for SAP HANA TDI > Backing up and recovering the SAP HANA database
Data Domain deduplication storage systems enable you to redefine SAP backup, archive, and availability with deduplication and consolidated data protection. Data Domain systems work seamlessly with a range of backup, archive, and enterprise applications.
Dell EMC’s new generation of midsize and large enterprise Data Domain systems are powered with flash SSD. For more information, see the Dell EMC Data Domain Deduplication Storage Systems Spec Sheet. By consolidating backup and archive data on a Data Domain system, you can reduce storage requirements, making disks cost-effective for onsite retention and highly efficient for network-based replication to disaster recovery sites.
The SAP HANA database provides a backup interface called Backint for SAP HANA. This backup interface enables third-party backup tools such as Dell EMC Data Domain Boost for Enterprise Applications (DDBEA) to connect to the backup and recovery capabilities of the SAP HANA database. Because Backint for SAP HANA is fully integrated into the SAP HANA database, you can individually configure data and log backups to be created and recovered using DDBEA.
A DDBEA backup to a Data Domain system uses the DD Boost feature as follows:
Configure the Data Domain system as follows:
/usr/sap/<SID>/SYS/global/hdb/opt
Alternatively, as shown in the following figure, create a symbolic link that points to the executable file by using the following command:
/usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint
ddbmadmin –P –Z <configuration_file>
Note: If you are configuring the multinode cluster, repeat steps 1–5 for all nodes.
For more information about configuring DD Boost software with SAP HANA, see the Dell EMC Data Domain Boost for Enterprise Applications and ProtectPoint Database Application Agent Installation and Administration Guide.
Backing up the database from SAP HANA Studio
Follow these steps:
The Specify Backup Settings dialog box appears.
Recovering the database with SAP HANA Studio
To recover the SAP HANA database to the point when you backed it up, follow these steps:
Using DDBEA software with the Data Domain system provides the following benefits:
Dell EMC solutions for SAP HANA are single-vendor, comprehensive offerings that address both database and data protection design and performance. We extensively tested this solution with the Data Domain system to ensure that customers receive an optimized and modern solution that accelerates time-to-value and protects their databases. We performed backup and restore performance benchmarking on a Dell EMC Ready Solution for a SAP HANA two-node appliance using a Data Domain DD6300 system. We used Dell EMC 14G PowerEdge R940 servers and an SC5020 array to create an initial database size of approximately 2.7 TB on the SAP HANA two-node appliance.
The following table shows the result of this backup and restore performance benchmarking.
Backup |
||||||||
|
DD Boost throughput (MB/s) |
Network throughput (MB/s) |
Post-compression data (GB) |
Backup duration (min) |
Node 1—backup server CPU usage (%) |
Node 2—backup server CPU usage (%) |
Total compression ratio (x) |
SAP HANA full data backup (TB) |
First backup |
889 |
704 |
2,396.5 |
56.5 |
1.4 |
1.5 |
1.3 |
2.77 |
Second backup |
3,844 |
183 |
158.4 |
14.0 |
2.8 |
2.7 |
21.3 |
2.87 |
Third backup |
4,025 |
117 |
99.6 |
13.8 |
2.8 |
2.7 |
36.9 |
2.96 |
Restore |
||||
Network out (MB/s) |
Restore duration (min) |
Node 1—backup server CPU usage (%) |
Node 2—backup server CPU usage (%) |
Note |
1,873 |
35 |
0.77 |
0.75 |
2.96 TB of the SAP HANA full data backup image. Does not include the time required to load the database into memory. |
The first complete database backup took longer because we saved a fresh data set to the DD6300 system. The total compression ratio (TCR) we obtained was only 1.3 (2.396 TB) compared to the initial 2.77 TB database.
For the second and third backups with 3 to 4 percent of new data, a full data backup of the database took only a quarter of the time required for the first backup. We also observed better Data Domain performance, as follows:
For more information about the backup and restore results we obtained, see Dell EMC SAP HANA Appliance Backup and Restore Performance with Dell EMC Data Domain.