Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
marieelieg
Expert
Posts: 122
Liked: 6 times
Joined: Oct 20, 2016 7:15 am
Contact:

backup SQL cluster

Post by marieelieg » 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
Expert
Posts: 122
Liked: 6 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: backup SQL cluster

Post by marieelieg » 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).

Mike Resseler
Product Manager
Posts: 5740
Liked: 611 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: backup SQL cluster

Post by Mike Resseler » 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

marieelieg
Expert
Posts: 122
Liked: 6 times
Joined: Oct 20, 2016 7:15 am
Contact:

Re: backup SQL cluster

Post by marieelieg » Oct 25, 2016 10:42 am

mmm Okay. Thank you Mike.

Vitaliy S.
Product Manager
Posts: 22991
Liked: 1556 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: backup SQL cluster

Post by Vitaliy S. » 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).

Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests