Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert

  • SAP HANA (HANA Cloud , HAAS OnPremise ..) offers offers comprehensive functionality to safeguard your database, including automatic backups for quick recovery in emergencies with a recovery point objective (RPO) of 15 minutes or less.

  • All SAP HANA Cloud instances undergo a daily full data backup automatically (with an every 15 minutes of log data backup), which is retained for 14 days i.e Instances can be recovered up to 14 days after the backup was taken.

  • Backups are encrypted using the advanced capabilities of the SAP Business Technology Platform to ensure data integrity and confidentiality.


#1. Backup and Recovery for the SAP HANA Cloud (BTP Cloud Foundry)

Automated Backups in SAP HANA Cloud :

  • Automatic backups are taken in SAP BTP HANA Cloud, without requiring any manual intervention from users.

  • Daily complete data backups of all SAP HANA Cloud instances are taken automatically.

  • Frequency of Log backups is every 15 minutes, similar to on-premise HANA.

  • SAP guarantees that database backups are taken correctly on a daily basis.

  • The recovery point objective (RPO) is no more than 15 minutes, which means that in case of system restoration, data loss may be up to 15 minutes.(see Backup and Recovery | SAP Help Portal).Usually, no data lose in recovery

  • The 24/7 Cloud Operation team monitors the backup status and detects any issues automatically.

  • Users can view backups and recover databases on selected periods through the HANA Cockpit UI in case of failures.

  • The purpose of establishing the recovery point objective is to ensure that log files are replayed during system restoration, with potential data loss limited to a maximum of 15 minutes.

  • Encrypted backups are saved for 14 days in an object store that is not tied to a specific availability zone.

  • Daily backups are only created when the database is online.

How to View HANA Database Backup

To view HANA database backup taken, follow the steps below
Open SAP HANA Cloud cockpit from your BTP Sub Account as shown below.

Then Choose Open SAP Hana Cockpit To Monitor & Administer.

Select the view Administration or All.Click on the card Database Backups.


You can view information about available database backups in the SAP HANA cockpit.

For more information, see Display Information About Backups in Card.

You can check info for log backup and also data backup .




There are Two options are available to recover an instance from backup:

  • Recovery to a selected point in time

  • Recreate instance


Recovery to a selected point in time

Using this option you can choose the point in time within the last 14 days. You can start the recovery process by selecting Start Recovery from the Actions menu in SAP HANA Cloud Central.


In SAP HANA Cloud Central --> click on 3 dots (...) in your Database instance --> Choose "Start Recovery" as shown below



Note : If you dont have access to SAP HANA Cloud Central , you can get URL & Database user Details from your BTP Sub-Account or Space Admin


Recreate instance

Using this option you can choose the availability zone into which the instance is recovered. You can start the recovery process by selecting Recreate Instance from the Actions menu in SAP HANA Cloud Central. You can use this option, for example, if an availability zone becomes unavailable, or if you wish to migrate your database to a different zone.

Additional Documentation

Automatic Recovery

Automatic failover/takeover of HANA Database possible, however recovery needs to be done manually as shown above. if you want to increase high availability for your Database , you could choose option "manage configuration", then add replications 


Key benefits of SAP HANA Cloud

Some of the key benefits of using SAP HANA Cloud

BTP with HANA Cloud can help businesses achieve high performance, scalability, flexibility, easy integration, reduced TCO, and predictable costs.

Managed services: HANA Cloud is a fully managed service, which means that maintenance, upgrades, and security are all taken care of by SAP. This helps free up time and resources for other critical business functions.

High performance : HANA Cloud leverages in-memory technology, which enables faster data processing and real-time analytics. This can help improve the performance of applications and enable faster decision-making.
Scalability: HANA Cloud is designed to handle large-scale data and complex workloads, making it easy to scale up or down as needed. This helps ensure that applications can handle changes in demand without performance degradation.

Consumption-based pricing,Predictable costs: HANA Cloud offers a consumption-based pricing model, which means that businesses only pay for the resources they use. This can help reduce costs and ensure predictable expenses.This can help ensure predictable costs and avoid overprovisioning.
Easy maintenance :HANA Cloud is a fully managed service, which means that maintenance, upgrades, and security are all taken care of by SAP. This can help reduce total cost of ownership (TCO) for businesses.
Language and framework flexibility: HANA Cloud supports multiple programming languages and frameworks, enabling developers to choose the most suitable tools for their projects. This can help improve productivity and the quality of the resulting applications.

Integration capabilities: HANA Cloud provides a wide range of integration options, making it easy to connect with other systems and services within the BTP ecosystem and beyond. This can help streamline workflows and improve overall efficiency.

#2. Backup and Recovery for the SAP HANA Service (BTP Cloud Foundry)

As mentioned in this technical article by denys.kempen


To View Backups list

Go to your BTP subaccount -> Space   View Dashboard  It opens “SAP HANA Service Dashboard”  Go to SAP HANA Cockpit

If you dont have access to Dashboard you can get URL & User Details from your BTP Sub-Account or Space Admin


To initiate a recovery, open a service request(ticket) with details mention in documentation

In the Description field, please provide the following details:

  • Global account name

  • Region

  • Instance ID

       Note : Instance ID is visible on the SAP HANA Service Dashboard.


Please also refer  FAQ: SAP HANA Database Backup & Recovery


Thank you for reading! If you enjoyed this post, please consider giving it a ‘'Like' ,'Share'  it with your friends and followers, and 'Follow' me for more content like this. Your support means a lot to me!

0 Kudos
How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance?

PLease usggest correct answer


1   In an SAP BTP CLI, execute the RECOVER DATABASE command with the

2   In the SAP HANA Cloud Central, select the Start Recovery option, and set the timestamp
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi mayur91 ,


Ideally, both options should function, with one being through a user interface (UI) and the other via Linux commands. Both choices hold equal viability , it is upto you as per your convenience .



0 Kudos
Do i understand correctly, I am not able to create full backups or PIT manually?  And full backups are created only automatically every 24h by SAP?

Will there be an option to do this by a click from customerside in the future? showkath.naseem
Product and Topic Expert
Product and Topic Expert
Hi noah-l  ,


Thank you for your question. As of [20/Dec/2023 😊], SAP BTP on HANA Cloud automatically performs backups every 24 hours. It's important to note that manual backups, or self-backups, are not available on HANA cloud (it is disabled ) directly through user-initiated clicks in the cloud environment.

To ensure regular and consistent backups, I recommend leveraging the automated backup mechanisms provided by SAP. You can check the backups in the cockpit under the 'Backup' card.

Additionally, you can use SQL queries like:



These queries allow you to view information about the backups.

If you have any more questions or if there's anything specific you'd like assistance with, feel free to let me know!




0 Kudos

Is it feasible to restore Production HANA DB to QA subaccount ? This is for BTP HANA Cloud Service and CF.  What are the alternatives?