Is SAP HANA, an integral component of a mission-critical data landscape?
Are you looking for a holistic solution
to protect your virtual and bare-metal SAP HANA instances?
Hello, my name is Anshul Nagori.
I'm a WorldWide Technical Marketing Engineer with HPE Storage
and today, I'm joined by Debanjan Banarjee
WorldWide Solution Architect with me.
And together, we're going to present
HPE and Veeam's solution for SAP HANA data management.
Let's begin.
Hello, my name is Debanjan Banarjee
and I'm the Worldwide Solution Architect for SAP,
working in product management team in Veeam.
In this session, we will talk about how you can protect SAP HANA workload
running anywhere,
for example On-Prem cloud or virtual machines.
We will also walk you through the new and the exciting features
of our latest release version 12,
at the later part of this video.
Starting at wider scope of Veeam Platform,
Veeam gives you the ability to backup almost any workload.
It can be cloud workloads, virtual machines
or any applications you can think of Microsoft, Oracle and of course SAP HANA,
unstructured data and physical workload.
and this gives organizations the ability to protect all of their data.
Veeams unique value proposition for SAP HANA
lies in its abilities to configure set up and manage SAP HANA Data Protection,
with utmost simplicity and intuitiveness.
Veeam offers three solutions to protect SAP HANA.
First, Veeam plugin for SAP HANA,
which utilizes the backend API that SAP provides.
Second, Veeam image level backups, which protect virtualized SAP HANA
running on VMware using pre-freeze and post-thaw scripts.
And third, Veeam agent for Linux
which protects SAP HANA running on bare-metal servers.
From V12 onwards, there is no need to
install the plugin manually in the client machine.
You can deploy the plugin directly in the backup and replication server.
To deploy the plugin, you have to add the HANA machine as a protection group,
and then you can deploy the plugin.
Another exciting feature in version 12 is that
you can directly schedule the backups
from the Veeam backup and replication server.
Let me show you this in a demo.
This, I have a system here DRP
OK and now first of all, you see that
there is no Veeam plugin for SAP HANA running
So when I just grep the RPM package, it is none.
So here I go in the VBR server,
I create a protection group call HANA.
I select individual computers.
and add the IP address of my HANA database server.
And of course, I need a Linux account
just for the demo purpose, I'm using the root credentials.
Now, here you can schedule the rescan policy.
How often you want it to be rescanned.
Rescan is like if there is any node added,
then you can rescan it.
So here you can have to click the install application plugins.
When you click Configure, you can click on SAP HANA.
And then Next
and what we will do is that it will push the plugin to
the HANA database server which is added as a protection group.
So soon you will see that
the plugin will be installed in the HANA database server.
So in this step you see, installing Veeam plugin for SAP HANA.
Ok. Let's check it again.
There you go. You see the latest plugin has been installed.
And now what I will do is I will schedule backup.
So here I will click Application and choose HANA.
Ok? And now if I select
the HANA database server and there you go, you see the DRP,
the tenant DB and the system DB.
So let's schedule the backup
Here we need to give two user OS user and the database user,
the OS user needs to be having the access to the HANA binary.
So here in our case is drpadm
and the database user is any user with a backup admin right.
So I have used VEMBACKUP as a backup user.
Ok, let's select to backup both the databases and click Next.
Now you can schedule the job.
So what will be the frequency to schedule it
and Finish.
So you will see that,
there is an application backup policy
for the SAP HANA which has been added here
and this will be running as per the schedule.
You can wait till the time get triggered
or you can manually click the Backup Now to backup the database,
if you want an adhoc backup.
So, right now it's 10:38
the backup will run at 10:39,
but we will just manually trigger a backup
You see the backup has been started.
Let's go and check it in the OS.
Great. You see the backup of the name server has been started.
Let's go and see in the catalog.
Ok? So here I see the backup from 3rd of March
for system DB and tenant DB.
Also see the log backups, which has been completed.
Veeam integrates with several backup repositories,
HPE StorOnce being one of them
HPE StoreOnce is a secure and powerful deduplicating backup appliance
offered as a bare-metal or a virtualized solution.
Veeam integrates with the HPE StoreOnce catalyst protocol to support features like
source site deduplication, ransomware resilience,
data immutability and backup to the cloud.
Let's take a look at the image level backup demo.
So first we add the HPE storage server,
click on the relevant storage server system
and then add the IP address or DNS hostname of it
and the web services API URL.
Next, we add the login credentials
and make sure that the configuration is appropriate.
This step is adding the storage server into Veeam backup entry replication UI.
once this storage system is added, we click on Finish.
So here we can see all the volumes which are part of this storage system.
Now we go to the SAP HANA VM
and we've copied the pre-freeze and the post-thaw scripts here already,
let me show you the contents of these files.
The first step is, in this file we change
the user name and password for the HANA system
its the database user name and password
and the same change needs to be done in the post-thaw script as well.
The next step is to start a backup job,
you can give a name to it.
Click Next here,
Select the SAP HANA VM.
make sure that the backup repository is the one that we have already created.
Click Next again
and click the Enable application-aware processing check box.
Here we click Edit,
go to the Script,
select Require Scripts Execution.
And basically we're going to create a link to these script on the HANA system
in the Veeam Backup Replication UI.
We have copied the scripts onto the local system
and we're going to browse it from the GUI.
and make sure that the SUIDing in the script is updated properly.
We do it for the pre-freeze script
and the same step for the post-thaw script as well.
Then they click OK.
We will need to give the guest OS credentials for the HANA system
and click on Test Now to see the connection, if it's working or not.
When it says it's successfully validated, you can now click Next
and click Apply.
There's an addon job.
So it will start as soon as I click Finish.
Now you can go to home
and go the Last 24 Hours option with the job running.
So here you can see the image level backup job has started,
you can check the SAP HANA studio screen,
when the job begins.
So it is doing the initial settings and connection
and fetching the VM information from the vSphere server.
Now you can see it has started running
the pre-freeze script and the post-thaw scripts
and a database snapshot is in progress.
So the post-thaw script has completed.
And now Veeam is saving data and transferring the contents
from all the VMDKs onto the backup repository,
which is in StoreOnce.
You can see the job progress on the screen.
The amount of time taken for this job depends on how big the database is
and also how much change occurs between two consecutive backups.
So that's how we do an image level backup of SAP HANA
with Veeam Backup and Replication UI.
Now let's take a look at the Restore.
So we select the Restore option,
Restore from Backup
Entire VM Restore.
Again, we select Entire VM Restore
and add the VM from Backup.
Here we select the particular virtual machine or the backup that we took.
Click on Add,
select the VM again, click Next,
restored to the same location or a new location based on our requirement.
Veeam will verify the VM and the backup on the backend
and then ask for the VM to get restarted.
Here you can see a full VM restore starting where it is basically
copying data back from the StoreOnce to the data store on the vSphere site.
It copies contents of all the VMDKs
regardless of the data log shared or the OS disk.
So you can see your restore has completed successfully.
This is the first part of the restore.
The second is to do a HANA recovery by going to HANA Cockpit or HANA Studio.
So we start the recovery wizard,
select the specific data backup option.
Click Next
and wait for the backup catalog to fetch the entry,
select the right snapshot, click Next
and then wait for the HANA services to get recovered.
So you can see the database has recovered
This is system database,
now need to repeat this process for the tenant database.
So now both the index server and access engine servers
have been restored and restarted.
And that's how you can recover an SAP HANA systems
using the image level backup with Veeam and HPE
Veeam also has the ability to recover anywhere,
giving organizations the flexibility
to make varieties of recovery choices.
All such capabilities make Veeam
the leader in data protection in todays market
To know more about our joint offerings.
Feel free to reach out to your Veeam or HPE representative today.
And if you like this video and found it useful,
hit the Like button and to watch more search technology videos
subscribe to the HPE or Veeam channel on YouTube.
Thanks for watching.