To view backup details, you can navigate to SAP HANA Backup app in HANA Cockpit. You can see the last backup status on the main screen and it can be customized.

SAP 32

When you open Data Backup app, you can see different options related to data backup. You can create a new backup or you can add schedules.

You can also see the last backup status, time, duration, size and destination type details under Backup Catalog details.

SAP 33

You can also perform SAP HANA Backup using HANA Studio. Navigate to Backup Folder in System view.

SAP 34

Overview Tab

This tab specifies the status of the currently running data backup and last successful data backup.

Backup now option can be used to run data backup wizard.

Configuration Tab

This tab specifies the Backup interval settings, file-based data backup settings, and logbased data backup setting.

Backup Interval Settings

Backint settings provides an option to use third party tool for data and log backup with configuration of a backing agent.

Configure the connection to a third-party backup tool by specifying a parameter file for the Backint agent.

File and Log Based Data Backup Settings

File-based data backup setting specifies the folder where you want to save the data backup on HANA system. You can change your backup folder.

You can also limit the size of data backup files. If the system data backup exceeds this set file size, it will split across the multiple files.

SAP 35

Log backup settings specify the destination folder where you want to save log backup on the external server. You can choose a destination type for log backup.

File − Ensures sufficient space in the system to store backups.

Backint − Special named pipe exists on the file system, however, require no disk space.

You can choose backup interval from the dropdown. It tells the longest amount of time that can pass before a new log backup is written.

Backup Interval − It can be in seconds, minutes, or hours.

Enable Automatic log backup option − Checking this option, helps to keep the log area vacant. If you disable this option, the log area will continue to fill and cause the database to hang.

Open Backup Wizard − To run the backup of system.

Backup wizard is used to specify backup settings. It specifies the Backup type, Destination type, Backup Destination folder, Backup prefix, the size of backup, etc.

SAP 36

Click Next → Review Backup settings → Finish. It runs the system backups and shows the time of complete backup for each server.

SAP HANA Admin – Recovery HANA System

To recover SAP HANA database, the database needs to shut down. Hence, during recovery, the end users or SAP applications cannot access the database.

Recovery of SAP HANA database is required in the following situations −

A disk in the data area is unusable or a disk in the log area is unusable.
As a consequence of a logical error, the database needs to be reset to its state at a particular point in time.
You want to create a copy of the database.

How to Recover a HANA System?

Choose HANA system → Right-click → Back and Recovery → Recover System.

SAP 37

Types of Recovery in HANA System

Most Recent State − Used for recovering the database to the time as close as possible to the current time. For this recovery, the data backup and log backup have to be available since the last data backup and the log area is required to perform the above type recovery.

Point in Time − Used for recovering the database to the specific point in time. For this recovery, the data backup and log backup have to be available, since last data backup and the log area are required to perform the above type of recovery.

Specific Data Backup − Used for recovering the database to a specified data backup. Specific data backup is required for the above type of recovery option.

Specific Log Position − This recovery type is an advanced option that can be used in exceptional cases where a previous recovery failed.

So, this brings us to the end of blog. This Tecklearn ‘SAP Hana Backup and Recovery’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

663