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.
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.
VeeamSAPVMwarevSphereSybase Database
Last Comment
Greg Stolar
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
- 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.
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