Backing up SQL Cluster using Shared VHDS

Hyper-V specific discussions

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: 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: 3340
Liked: 379 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


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 12 guests