Protecting SQL VMs

VMware specific discussions

Protecting SQL VMs

Veeam Logoby gingerdazza » Tue Sep 15, 2015 3:57 pm

Obviously, as some services like SQL become increasingly first class citizens with the infrastructure with higher I/O burdens, am I right to assume that generally everyone moves away from using Veeam? I say this because normally with a high importance and high I/O SQL platform you probably have tighter RPOs. If you do have tighter RPOs (perhaps 60 minutes), utilising Veeam replication means hourly stun, which is often an unacceptable side affect to be experiencing so often.

We want to remain a SQL Standard house if possible, we want OS maintenance capabilities and we don't want any re-pointing of apps should we have a site DR event (I know - a lot of want!!). I wonder how many of you also have higher end virtual SQL platforms and how you get the balance right?

I see that Zerto might be a nicer fit alongside a Windows MSCS cluster, but be interested to see what else you guys are doing.

Thanks
gingerdazza
Enthusiast
 
Posts: 93
Liked: 3 times
Joined: Tue Jul 23, 2013 9:14 am
Full Name: Dazza

Re: Protecting SQL VMs

Veeam Logoby Vitaliy S. » Tue Sep 15, 2015 5:02 pm

Hi Dazza,

gingerdazza wrote:am I right to assume that generally everyone moves away from using Veeam?

I would say that most of the people move from using backup jobs on hourly basis to using SQL backup jobs, which have a separate RPO configuration.

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19540
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Protecting SQL VMs

Veeam Logoby gingerdazza » Wed Sep 16, 2015 7:43 am

Hi Vitaliy

thanks for this information, but this continuous logs backup also uses hypervisor snapshots too doesn't it? This is the part that doesn't make sense to me, because it means you have a regular stun on the SQL server, no? Wouldn't people be better doing nightly VM backups alongside native SQL log shipping to avoid stun?
gingerdazza
Enthusiast
 
Posts: 93
Liked: 3 times
Joined: Tue Jul 23, 2013 9:14 am
Full Name: Dazza

Re: Protecting SQL VMs

Veeam Logoby Vitaliy S. » Wed Sep 16, 2015 10:04 am 1 person likes this post

gingerdazza wrote:but this continuous logs backup also uses hypervisor snapshots too doesn't it?

No, it doesn't. During sql backup job run VM snapshot is not taken, it is similar like doing logs backup via native tools, but on top of that we also provide SQL Explorer restore capabilities.
Vitaliy S.
Veeam Software
 
Posts: 19540
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Protecting SQL VMs

Veeam Logoby DeaconZ » Wed Sep 16, 2015 12:32 pm

Very good info Vitaliy! Thank you. We are facing similar RPO/RTO requirements for our SQL databases. We also are implementing SQL 2014 Always On Availability Groups with 3 nodes each. 2 in the prod DC, 1 in the DR DC. Any tips on backing up Always On groups?

I did read this: http://helpcenter.veeam.com/backup/80/v ... pport.html
DeaconZ
Influencer
 
Posts: 14
Liked: 3 times
Joined: Fri Jul 09, 2010 7:39 pm

Re: Protecting SQL VMs

Veeam Logoby Vitaliy S. » Wed Sep 16, 2015 12:51 pm

There is an existing topic about Always On groups backup as well, please check it out > Backing up Always On MSSQL with Veeam
Vitaliy S.
Veeam Software
 
Posts: 19540
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to VMware vSphere



Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Yahoo [Bot] and 27 guests