Backing up SQL Cluster using Shared VHDS

Discussions specific to Microsoft Hyper-V hypervisor

Backing up SQL Cluster using Shared VHDS

Veeam Logoby dschuler » Wed Jun 28, 2017 1:54 pm

We recently upgraded our Hyper-V Cluster to 2016 and are in the process of deploying new SQL Clusters within it using the new Shared VHDS in 2016. We are looking for some best practices on how to configure the job to do Application Aware Processing on the SQL Instances.

The SQL Cluster will be Server 2016 running SQL 2016 in a 2 node Active/Passive configuration. In the past on Hyper-V 2012 with a Guest Server 2012 SQL Cluster using the Shared VHDX's what we were doing was to run the backups of all the volumes from the Passive node and only backup the C: drive of the Active node, this just reduced the stress on the active node during the backup. But 2012 didn't allow us to do Application Aware Processing so all we were getting was crash consistent backups of the volumes. We aren't sure if that same method will work with Application Aware Processing now that we can do that with 2016.

Has anyone done something similar yet or know of any KB articles on best practices for this type of arrangement? We are getting close to finishing up our Test Cluster, so we may need to be the guinea pigs here and just test out a few different methods to see what works best.
dschuler
Novice
 
Posts: 4
Liked: never
Joined: Mon Aug 29, 2016 4:35 pm
Full Name: Dann Schuler

Re: Backing up SQL Cluster using Shared VHDS

Veeam Logoby Mike Resseler » Thu Jun 29, 2017 5:37 am

Unfortunately no.

MSFT promised us with the new Shared VHDSet with 2016 that application consistent backups would be possible to be taken. But it still doesn't work at this moment (unless it was fixed in one of the rollup updates but I haven't heard about it).

This means that you will be back to the same method for now unfortunately.
Mike Resseler
Veeam Software
 
Posts: 3886
Liked: 430 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Backing up SQL Cluster using Shared VHDS

Veeam Logoby Cragdoo » Fri Nov 10, 2017 11:26 am

any update on the use of VHDS? Given there was a blog post in August 2017 from Veeam about how to create VHDS

https://hyperv.veeam.com/blog/virtual-h ... ion-guide/
Cragdoo
Veeam Vanguard
 
Posts: 473
Liked: 156 times
Joined: Tue Sep 27, 2011 12:17 pm
Location: Scotland
Full Name: Craig Dalrymple

Re: Backing up SQL Cluster using Shared VHDS

Veeam Logoby foggy » Fri Dec 08, 2017 3:54 pm

Seems that nothing has changed so far.
foggy
Veeam Software
 
Posts: 15750
Liked: 1183 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backing up SQL Cluster using Shared VHDS

Veeam Logoby dschuler » Tue Dec 19, 2017 6:37 pm

I know it might be a little early to be asking this, but does Update 3 resolve this issue? I am going to deploy it this week and will build a new Hyper-V Cluster and a Guest Cluster to test on but would like to hear from anyone else who is experimenting with it.
dschuler
Novice
 
Posts: 4
Liked: never
Joined: Mon Aug 29, 2016 4:35 pm
Full Name: Dann Schuler

Re: Backing up SQL Cluster using Shared VHDS

Veeam Logoby nmdange » Tue Dec 19, 2017 6:52 pm

This is a Microsoft issue so Veeam updates won't do anything. All we can do is hope a Cumulative update to Windows Server 2016 fixes or (or it's fixed in a future build like 1803)
nmdange
Expert
 
Posts: 263
Liked: 64 times
Joined: Thu Aug 20, 2015 9:30 pm

Re: Backing up SQL Cluster using Shared VHDS

Veeam Logoby spgsit5upport » Sun Jan 21, 2018 2:49 pm

That is total **** from MS
spgsit5upport
Expert
 
Posts: 187
Liked: 14 times
Joined: Fri May 28, 2010 10:25 am
Full Name: Seb


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 1 guest

cron