backup SQL cluster

Hyper-V specific discussions

backup SQL cluster

Veeam Logoby marieelieg » Tue Oct 25, 2016 5:57 am

Hello everyone,

I don't know if someone asked this question already but nevertheless.

I have a 2 node SQL cluster on hyper-v hosts. Each node has a local drive (lets say C:\ drive) and both of them have a shared SAN volume.
I am able to backup the local drives just fine however Veeam is not able to "see" the SAN shared volume.

My question is, in Veeam is there a way to backup the SAN shared volume? If yes, how to do it?

Thank you guys in advance. Any help is really appreciated:D
marieelieg
Enthusiast
 
Posts: 66
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: backup SQL cluster

Veeam Logoby marieelieg » Tue Oct 25, 2016 6:49 am

SQL cluster is on windows server 2012 R2.
And it is not Always on (not sure if that matters).
marieelieg
Enthusiast
 
Posts: 66
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: backup SQL cluster

Veeam Logoby Mike Resseler » Tue Oct 25, 2016 9:02 am

Hi,

No it is not since that shared volume is not part of the virtual infrastructure. The only way to be able to do this is to work with a shared VHD(X). Unfortunately, in windows 2012 R2 the capabilities of backing-up a shared VHD(X) only allowed us to take a crash-consistent backup. I can't say yet what we can do in server 2016 (but hoping it will be better...)

So for now, we can't backup that shared volume, and maybe you can let your SQL admins make SQL dumps on a regular basis and put that data on a virtual disk (so we can back it up). In the future, we are hoping to see better support for shared disks (if the underlying technologie allows us at least... ;-)) so you can move the data to that (and get additional virtualization benefits with it). Also, considering how fast technology is changing, you might be interested to look at Always on technologies because that would stop the hassle of shared disks, and gives you more possibilities for the future

My 2 cents
Mike
Mike Resseler
Veeam Software
 
Posts: 3290
Liked: 366 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: backup SQL cluster

Veeam Logoby marieelieg » Tue Oct 25, 2016 10:42 am

mmm Okay. Thank you Mike.
marieelieg
Enthusiast
 
Posts: 66
Liked: 3 times
Joined: Thu Oct 20, 2016 7:15 am

Re: backup SQL cluster

Veeam Logoby Vitaliy S. » Tue Oct 25, 2016 1:43 pm

Depending on the volume type and your setup it might be possible to use Veeam Endpoint Backup to protect this other volume, just databases (as an alternative to native application backup dumps).
Vitaliy S.
Veeam Software
 
Posts: 19707
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 5 guests