Link to home
Create AccountLog in
Avatar of Greg Stolar
Greg Stolar

asked on

Backup Database SAP HANA and Sybase ASE 11 on VMWare with or without Veeam

I had this question after viewing Backing up Sybase database Server using Veeam.

Hi,

I'm new in experts-exchange community. My company is on the way to use SAP Solutions. Right now I must choose backup concept for all VM's and databases. As far I know HANA backs up relatively automatic (dumps database and logs from RAM to storage). The issue what keeps me not sleeping is backup from Sybase ver. 11 databases, as database shouldn't be stopped at any time (24/7 availabilty) and this version have no support for VSS. I've readed that it's possible to HA (High Availabilty) and DR (Disaster Restore) only with VMWare solutions but I'm not sure - will consistency of database not be corrupted?...
Can someone give me a Tip what would be the best solution?
Database: Sybase 11
VMWare: vSphere 5.5
Veeam: 9.5.0.823
Many thanks for Your replies.
Avatar of Luciano Patrão
Luciano Patrão
Flag of Portugal image

Hi,

Did not understand what is really the question.

Do you want to backup all VMs (and also those Sybase Databases) with Veeam? If that Sybase doenst support VSS, then you need to do a prefreeze/postthaw scripts in conjunction with Veeam B&R backup job to back it up. Honestly is not easy to do that with that version.

Regarding VMware HA did not understand the question. What you plan here? HA will simple restart the VM from a ESXi host or Host network failure, in another host.

If is 24/7 high availability that you need, Fault Tolerance (FT) honestly don't know if the best solution here. Because even Sybase Cluster and HA (from SAP not VMware) from that version is very old to have a proper solution.

If you could clarify better what you need, then we can give a better solution.

Jail
ASKER CERTIFIED SOLUTION
Avatar of Greg Stolar
Greg Stolar

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Greg Stolar
Greg Stolar

ASKER

Also I've solved this problem in such form:
- VM Replication with Failover management
- Drop Database + Transaction on databases without VSS capability - once a week drop database and each 15 minutes drop transaction (compromise between DB availabilty and the speed of recovery)
- Additionally all VM are saved on Tapes in Veeam once a day

@Luciano - many thanks for Your Info's! I used them as well.