Nmedia - Fotolia
SAP HANA is a relational database that is designed to reside in memory. By using an in-memory data platform, SAP HANA can achieve better overall performance than would generally be possible if the database columns resided on disks.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
As is the case with disk-based databases, however, SAP HANA backup is a necessary safeguard against data loss.
Although HANA is an in-memory database, it also uses persistent storage just like any other database. Otherwise, HANA would be vulnerable to power failures. As such, the first best practice is to decide what needs to be backed up.
HANA divides persistent storage into two areas -- the data area and the log area. The data area contains all the data volumes -- with one data volume per service -- and each data volume contains both the data and the undo log entries for the associated service.
The log area contains all of the log volumes, and there is a log volume for each service. Each log volume contains log segments, which, in turn, store redo log entries. Log segments can be overwritten once they have been backed up.
File system, Backint and snapshot SAP HANA backup
There are three options for SAP HANA backup -- file system, Backint and snapshot. You can also mix backup methods. These backup methods can be used to create full, incremental or differential backups.
Each SAP HANA backup method involves tradeoffs, so it is important to determine which method is best suited to your own needs.
File system backups protect only the current data, as opposed to the entire data area, and perform block-level consistency checks. However, file system backups place a load on the network, and it is necessary to monitor the file system fill level.
The Backint method is an API-based method, and it usually refers to SAP HANA backup using a third-party utility. Like a file system backup, this method also performs block-level consistency checks and only backs up the current data rather than the entire data area. Because this method enables integration with third-party backup utilities, it fits neatly into an organization's existing backup infrastructure, and it enables features such as backup encryption and data reduction.
The third option is to create a snapshot. Snapshots can be created or applied very quickly, and snapshots do not create the network load that file system and Backint backups do. However, snapshots do not perform block-level consistency checks, nor do they enable you to use third-party backup tools.
Dig Deeper on Data storage backup tools
Related Q&A from Brien Posey
Expect data protection technologies to veer toward an expansion of recovery capabilities, as organizations need to be able to recover in multiple ...continue reading
Health IT expert Brien Posey offers some examples of multifactor authentication as a way for hospitals to further safeguard access to protected ...continue reading
IT can take a few steps to make the move to Windows 10 easier on users, including considering an in-place upgrade and holding off on any other major ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.