-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 08, 2020 2:25 pm
- Contact:
Backup Strategy
Hi all,
I am new to Hana and and I have a few questions about best HANA backup strategy. My SAP System on HANA DB is installed on two different servers: Server1 is SAP Applikation and Server2 is HANA DB.
Would this be the best backup strategy for HANA systems?
1. daily snapshot of both VM servers: application server(server1) and HANA DB(server2) on vmware. Do I have to run pre-freeze and post-thaw scripts here?
2. daily backup HANA DB(server2) via the backint interface.
If I want to restore the systems, in which sequence does it happen?
First I restore my application server and HANA server from Snapshot. after that I restore the database. Is that correct ?
Thanks a lot.
Best Regards
I am new to Hana and and I have a few questions about best HANA backup strategy. My SAP System on HANA DB is installed on two different servers: Server1 is SAP Applikation and Server2 is HANA DB.
Would this be the best backup strategy for HANA systems?
1. daily snapshot of both VM servers: application server(server1) and HANA DB(server2) on vmware. Do I have to run pre-freeze and post-thaw scripts here?
2. daily backup HANA DB(server2) via the backint interface.
If I want to restore the systems, in which sequence does it happen?
First I restore my application server and HANA server from Snapshot. after that I restore the database. Is that correct ?
Thanks a lot.
Best Regards
-
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Backup Strategy
Hello,
and welcome to the forums.
Yes, your strategy sounds good. HANA scripts are available at veeamhub.io
And there is also a whitepaper that should give some more details https://www.veeam.com/wp-veeam-sap-hana ... e-v19.html
Best regards,
Hannes
and welcome to the forums.
Yes, your strategy sounds good. HANA scripts are available at veeamhub.io
And there is also a whitepaper that should give some more details https://www.veeam.com/wp-veeam-sap-hana ... e-v19.html
Best regards,
Hannes
-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 08, 2020 2:25 pm
- Contact:
Re: Backup Strategy
Hello Hannes,
Many thanks for the answer.
Do the pre-freeze and post-thaw scripts have to be executed on both servers (SAP application server and HANA DB server)? Can be used the same script on both servers (applikation Server and HANA Server) ?
Where can I read how to create these scripts?
Many thanks for the help.
Best Regards
Many thanks for the answer.
Do the pre-freeze and post-thaw scripts have to be executed on both servers (SAP application server and HANA DB server)? Can be used the same script on both servers (applikation Server and HANA Server) ?
Where can I read how to create these scripts?
Many thanks for the help.
Best Regards
-
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Backup Strategy
Hello,
the scripts are for HANA (the name is "hana-pre-freeze.sh" ) I have not heard, that the application server requires any scripting.
Best regards,
Hannes
the scripts are for HANA (the name is "hana-pre-freeze.sh" ) I have not heard, that the application server requires any scripting.
I'm not sure what you mean. The script already exists. It just needs to be configured.Where can I read how to create these scripts?
Best regards,
Hannes
-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 08, 2020 2:25 pm
- Contact:
Re: Backup Strategy
Hello Hannes,
many thanks for your reply.
Where can I download these scripts? Do the scripts have to be adapted to my VM and DB.
And one more question, is the DB stopped (with these scripts) before the snapshot?
Many Thanks
Best Regards
many thanks for your reply.
Where can I download these scripts? Do the scripts have to be adapted to my VM and DB.
And one more question, is the DB stopped (with these scripts) before the snapshot?
Many Thanks
Best Regards
-
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Backup Strategy
Hello,
uhm, did you see the whitepaper I linked and the http://veeamhub.io domain I mentioned ("applications" is the way to go)?
Both have the same link to the scripts including explanations what it does.
The databases keeps running. It is not stopped.
Best regards,
Hannes
uhm, did you see the whitepaper I linked and the http://veeamhub.io domain I mentioned ("applications" is the way to go)?
Both have the same link to the scripts including explanations what it does.
The databases keeps running. It is not stopped.
Best regards,
Hannes
-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 08, 2020 2:25 pm
- Contact:
Re: Backup Strategy
Hi Hannes,
Many thanks!!!
Just one last question. Where should these scripts be set up: on the HANA server or on the Veeam server?
Many Thanks
Best regards
Many thanks!!!
Just one last question. Where should these scripts be set up: on the HANA server or on the Veeam server?
Many Thanks
Best regards
-
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Backup Strategy
Hello,
Page 24 of the whitepaper has the picture, where the script needs to be added to the backup job. General information about scripts are available in the user guide: https://helpcenter.veeam.com/docs/backu ... ml?ver=100
Best regards,
Hannes
do I get a beer if you have another one?Just one last question.
Page 24 of the whitepaper has the picture, where the script needs to be added to the backup job. General information about scripts are available in the user guide: https://helpcenter.veeam.com/docs/backu ... ml?ver=100
Best regards,
Hannes
-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 08, 2020 2:25 pm
- Contact:
Re: Backup Strategy
Hello Hannes,
many thanks for your help. Although I can not spend a beer, I ask one more question
Do these scripts have to be stored somewhere on the hana server or just built into Veeam job?
Many Thanks
Best regards
many thanks for your help. Although I can not spend a beer, I ask one more question
Do these scripts have to be stored somewhere on the hana server or just built into Veeam job?
Many Thanks
Best regards
-
- Product Manager
- Posts: 9848
- Liked: 2607 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Backup Strategy
Scripts will be always placed on veeam server and copied to the vm (Application-aware processing feature is used for copying and running the scripts) when the backup job starts.
Product Management Analyst @ Veeam Software
Who is online
Users browsing this forum: No registered users and 64 guests