O'Reilly logo

SAP HANA Cookbook by Ganesh Mahadevan V., Chandrasekhar Mankala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding backup and recovery

In the SAP HANA database, during normal operation, data is automatically saved to the disk at regular savepoints. Furthermore, the log captures all the data changes. After each committed database transaction, the log is saved from the memory to the disk. When there is a power failure, the database can be restarted like any disk-based database, and it returns to its last consistent state by replaying the log since the last savepoint.

The backups are required for the following reasons:

  • To protect against disk failures
  • To make it possible to reset the database to an earlier point in time

Backups are carried out while the database is running and users can continue to work normally. The impact on system performance is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required