SAP B1 HANA Support?

[Andreas Neufert]

Based on
http://help-legacy.sap.com/saphelp_hana ... ontent.htm
you can add "COMPLETE" to the backup catalog delete command to do this.

PURGESQL1="BACKUP CATALOG DELETE ALL BEFORE BACKUP_ID COMPLETE"


BTW. the newest version can be found at github. If you want to participate and add ideas to the script you are welcome.

[tdewin]

BTW. the newest version can be found at github. If you want to participate and add ideas to the script you are welcome.

would be here : https://github.com/VeeamHub/application ... r/sap-hana

[Andreas Neufert]

thanks Timothy I missed to add the link.

[PKaufmann]

Hey everyone,

I was just informed that my company is planning to upgrade to HANA 2.0 SPS2

My colleague told me that with HANA 2.0 there is no single-tenant system anymore, all HANA 2.0 Systems are multi-tenant..

As multi-tenant was not supported for storage/vmware snapshots with version 1.0 SPS12 or above,
I am not sure if this script will still work with Hana 2.0 ..

my colleague is setting up a HANA 2.0 test-system, soon, but maybe someone has already some experience with it?

[Andreas Neufert]

Yes, SAP change even single databases to a multi-tenant system.
Anyway SAP support a single DB per server muti-tenant database for snapshot processing.
Please check the VeeamHub for latest script (above link)

[PKaufmann]

thanks for the reply..

checked the link above but everything seems to be a year old or something.
Do I have the current link ?
https://github.com/VeeamHub/application ... r/sap-hana

[tsightler]

Sorry, I was still squashing bugs in the new version. I'll push it out right now.

[tsightler]

OK, new version is pushed. This version has a lot of changes/enhancements from the previous script, including debug/test mode, the ability to use an external configuration file (default in /etc/veeam/hana.conf) which allows you to keep different configs on each server yet use the same script on the Veeam server (also makes script upgrades easier). The script also automatically detects the HANA version and attempts to "do the right thing" for HANA 2.0 SP1 and later. It's been tested by a few customers with a number of HANA instances, but certainly interested in more feedback.

One important note, snapshot backups are still only supported in the case where there is a single tenant, even on multi-tenant databases so, while every databases is technically multi-tenant, only a single tenant is allowed if you want to backup that instance with Veeam.

[PKaufmann]

big thanks, got it!

[russell01]

Hi TSightler / Veeam,

Can you confirm if this script works correctly in SAP HANA 2.0 SP02?

In this version the SYSTEM Database and HANA Instance Database are split, so you technically have two separate SAP HANA tenant databases to "Backup / Pause / Resume".

Since this is the enforced design in all SAP HANA versions going forward this is critical to support.

Regards,

Russell Wilson

[tsightler]

SAP HANA 2.0 SP02 is supported by the current versions of the script and has been tested, however, it only works in the case where there is a single tenant database, i.e. the SYSTEM database plus a single HANA instance database. If you have more than one tenant database as part of that instance, snapshot backups are not supported by SAP.

The script automatically detects HANA version 2.0 SP01 and higher and makes the correct adjustments to connect to the SYSTEMDB and to include the "FOR FULL SYSTEM" string as part of the snapshot command. This instructs HANA to snap not just the SYSTEM database but the tenant database as well:

https://help.sap.com/viewer/4fe29514fd5 ... 5a4a2.html

The version detection is performed automatically so that systems with a mix of both 1.2 and 2.0 will still "just work". If you decide to use keystore based authentication, be sure to read the comments in the script carefully as you must explicitly specify the user is for the SYSTEMDB and also use a different port number. There is an example command in the comments.

Much thanks to the users who have tested these new versions of the scripts and helped me to flush out various bugs. I believe the scripts is working very well at this point, but feel free to report any issues and I'm happy to pursue them. I just squashed several more bugs last week due to user reports. Github always holds the most current, tested version.

[russell01]

Thanks for the confirmation, i will implement this on our test systems and let you know if i have any issues! Do you know if this will be included in Veeam B&R 10?

[Andreas Neufert]

It is a common feature request and we are looking into this topic overall. We can not comment by design of our release process about any timeline.

[kris2fe]

Hello !!
Do you have a roadmap for SAP HANA support on Veeam ?

[foggy]

Hi Christophe, we do not have a roadmap to share, but this request is on our table. Thanks.

[mheckel]

Hello everybody,

1) Storage: Should I enable the exlucsion of swap file blocks?
2) Storage: I think it´s a good idea to backup from storage snapshots, isn´t it?
3) Guest processing:Is there a need to activate apllication-aware processing, if I backup SAP hana with pre-freeze / post-thaw scripts?
3.1) If yes, should I let veeam backup / truncate the SQL logs?

Thanks.

[jmmarton]

1) Storage: Should I enable the exlucsion of swap file blocks?

I can't speak to the rest of your questions, but in general any job containing Windows VMs using NTFS will take advantage of this feature. I don't see any reason not to enable swap file exclusion.

Joe

[foggy]

3) Guest processing:Is there a need to activate apllication-aware processing, if I backup SAP hana with pre-freeze / post-thaw scripts?

Yes, otherwise you wouldn't be able to specify pre-freeze/post-thaw scripts.

3.1) If yes, should I let veeam backup / truncate the SQL logs?

Log truncation settings apply to Exchange/SQL only.

[mheckel]

Yes, otherwise you wouldn't be able to specify pre-freeze/post-thaw scripts.

Pre / Post scripts is part of the storage section, noch appliaction awareness?!

Additional info: It´s a Linux Red Hat VM.

[PTide]

Scripts in the storage section are pre/post-job. Pre-freeze/post-thaw script settings are located in the Guest Processing settings.

Thanks

[crackocain]

Hi

I read "THE WORD FROM GOSTEV" today.
He mentioned SAP Native plug in. I wonder this plug in is SAP certified or use BACKINT Api?

"Finally, something we didn't talk about before! Another enterprise application we had LOTS of requests from you to support natively is SAP HANA. We've actually been working on Veeam Plug-in for SAP HANA for a while now, and based on the results of the recent alpha testing with select customers, we've decided to shoot for including one in the Update 4 as well. Even if we didn't plan on including this one into the Update 4 originally, we decided it will be a shame not to at least try our best to ship it sooner, given the very positive feedback so far. Both Oracle and SAP HANA plug-ins are currently in private beta, so if you want to test them out and provide your feedback – as always, check with your Veeam sales rep if they have any private beta spots available (note that these are typically limited to just a few per sales region to control load on our sales engineers – so thank you for understanding in advance)."

[Gostev]

Yes, it does use BACKINT and we will certainly be certifying one with SAP once it is shipped. Thanks!

[Gostev]

Just to follow up on this, the plug-in has been certified with SAP.

[Regnor]

Great news.
Will the plug in also be available on the U4 release date?

[Gostev]

Yes, it's a part of Update 4 (you will see it on the installation ISO).

[Regnor]

Thank you for the hint

[crackocain]

Hi Anton

Great feature for enterprise customers. When does it start appearing on the certified list?

https://wiki.scn.sap.com/wiki/pages/vie ... =451067853

[Gostev]

When the product becomes generally available (SAP rule). We're trying to coordinate that it happens the same day, but you never know if someone important ends up being on vacation just when we need her

[crackocain]

Supporting IBM Power Processor?

[Andreas Neufert]

Linux on IBM Power is not supported in this first version.