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.
Posts: 3
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: 3490
Liked: 390 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 ... ion-guide/
Veeam Vanguard
Posts: 440
Liked: 152 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.
Veeam Software
Posts: 15377
Liked: 1139 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Return to Microsoft Hyper-V

Who is online

Users browsing this forum: No registered users and 1 guest