Host-based backup of Microsoft Hyper-V VMs.
Post Reply
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

Best SQL Server design worked with VAEEM

Post by Someonenew2014 »

Hi..

I'm assessing ALWAYSON with SQL server. Currently we have two nodes clustered configured under VHDX and have VAEEM backup v.8. According to vaeem backup is supported under crash-consistent state ( please elaborate I read documentation but nor got the idea).


My question if I change from failover cluster instance to Always-On, will Vaeem support both backup and replication like any other disks? I'm not big fan of Clustering on virtual servers. However, I'm looking for something can help me out to reach a good design and get benefits from many third parties like VAEEM.


I would like to hear about Always-ON vs FCI from VAEEM perspective. Thank you.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Best SQL Server design worked with VAEEM

Post by veremin »

According to vaeem backup is supported under crash-consistent state ( please elaborate I read documentation but nor got the idea).
Yep, shared vhdx can be backed up only in crash consistent mode.
My question if I change from failover cluster instance to Always-On, will Vaeem support both backup and replication like any other disks?
Yep, starting from version 8 we do support SQL Always-On.
I would like to hear about Always-ON vs FCI from VAEEM perspective.
Can you elaborate on that? What is particular information you're looking besides the fact that one scenario guarantees nothing but crash-consistency, while the other consistency on application level?

Thanks.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

Re: Best SQL Server design worked with VAEEM

Post by Someonenew2014 »

Thanks for your reply.


1- What is different between crash-consistent mode and other modes as well?
I read the documentation but not able to understand.

2- Can I make /backup replication for AlwaysOn SQLCluster (No shared storage and it is a VHDX)?
if yes, in all modes or in crash consistent state only.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Best SQL Server design worked with VAEEM

Post by veremin »

Application consistency means all application specific operations are frozen in appropriate manner prior to taking a snapshot. Without that, machine will be in crash-consistent state - the same as it would be after a system failure or power outage. More information about Application Aware Image Processing can be found here.

Without shared VHDX you can backup AlwaysOn Cluster in application consistent manner.

Thanks.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

Re: Best SQL Server design worked with VAEEM

Post by Someonenew2014 »

Thanks. I got it.

Ok what about replication of AlwaysOn cluster that is installed under VHDX (not shared)?
Is supported in application consistent manner?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Best SQL Server design worked with VAEEM

Post by veremin »

Is supported in application consistent manner?
Correct. In terms of consistency there is no difference between replication and backup jobs.
Post Reply

Who is online

Users browsing this forum: No registered users and 27 guests