SQL Server VM´s in a Cluster with iSCSI Target

Hyper-V specific discussions

SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby JaYaKaAzZ » Mon Feb 03, 2014 8:20 am

Hello,

we have a Problem to backup our SQL Servers. They are VM´s on different Hyper-V Hosts and they have iSCSI Lun´s connected because we put them into a Cluster.

Is there a possiblity to backup the VM´s with the iSCSI Luns ? I know with Hyper-V you can just add the iSCSI LUN only as .vhd to the VM´s to be sure that they will be backed up, but then we have no cluster anymore !? With ESX you dont have this problem because of RDM but is there a Solution for Hyper-V ???

Does anyone have the same Problem ??


Greetings

Jay
JaYaKaAzZ
Influencer
 
Posts: 24
Liked: 4 times
Joined: Mon Feb 03, 2014 8:01 am
Full Name: Artur Schneider

Re: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby foggy » Mon Feb 03, 2014 9:03 am

Artur, disks connected via in-guest iSCSI initiator are not supported and are automatically skipped from processing.
foggy
Veeam Software
 
Posts: 14729
Liked: 1078 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby Vitaliy S. » Mon Feb 03, 2014 12:47 pm

Artur,

Can you please tell me why do you use such configuration? For high availability purpose?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19546
Liked: 1100 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby mate.ivanszky » Wed Feb 26, 2014 11:52 am

I also have a similar issue.
VEEAM does not support backing up in guest iSCSI mounted drives. You have to use RDM or Shared Virtual Disk. If your setup contains SQL Failover Cluster you cannot go with Shared Virtual Disk as it is not supported in Microsoft clustering.
Unfortunately RDM is not an option either for me as I am on iSCSI storage (3PAR) therefore I have to rely on SQL backup until a workaround is found (e.g. Storage snapshot on 3PAR iSCSI array - still not supported)
mate.ivanszky
Novice
 
Posts: 7
Liked: never
Joined: Sat Sep 07, 2013 2:38 pm
Full Name: Mate Ivanszky

Re: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby matt306 » Wed Feb 26, 2014 3:31 pm 1 person likes this post

The OP probably has these iSCSI LUN's in the VM, as the standard advice from Microsoft for years has been to put SQL/Exchange workloads onto pass-through disks. Using iSCSI in the VM neatly gets around any HA problems using pass through.

All of our SQL, Exchange and File servers were setup the same way and we managed to convert these to VHD/VHDX without experiencing any performance degradation. We are a large-ish organisation with 1300 users (with mailboxes) running a number of financial and training DB's.

Microsoft in recent times have suggested that their VHDX format is now comparable in terms of performance with pass through and a number of MVP's have stated that keeping pass-through disks in a virtualised environment is counter intuitive and limits your options.
matt306
Influencer
 
Posts: 19
Liked: 11 times
Joined: Mon Jan 06, 2014 2:29 pm
Full Name: Matthew Brown

Re: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby matt306 » Wed Feb 26, 2014 3:35 pm

I should caveat my last statement by saying that this applies to Hyper-V Clusters not SQL Clusters.
matt306
Influencer
 
Posts: 19
Liked: 11 times
Joined: Mon Jan 06, 2014 2:29 pm
Full Name: Matthew Brown

Re: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby Mike Resseler » Wed Feb 26, 2014 3:38 pm 1 person likes this post

Matthew is indeed right.
While pass-through has been pushed for many years by MSFT they are now changing that vision. Reasons enough, and one of them is that you cannot protect that data that's on the pass-through disk(s) through virtualiation protection unless you use workarounds such as windows server backup of that volume to "somewhere" or in application backups.
My advice here would be to look at your setup and see if the SQL configuration you have can be adapted to another strategy (like Always-on for example) so that you can use VHDX for your data volumes and not only profit from virtualization data protection but also have ALL the flexibility and functionality of virtualization at your hands for your SQL servers...
My 2 cents
Mike
Mike Resseler
Veeam Software
 
Posts: 3150
Liked: 362 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: SQL Server VM´s in a Cluster with iSCSI Target

Veeam Logoby samh22a » Fri Feb 28, 2014 2:00 am

main problem with always-on is that it requires SQL enterprise. we have a lot of server cluster running on our hyper-v hosts and it seems we will have to keep another backup solution around just for this.
I would be willing to install an agent within my sql servers if it would allow veeam to back it up properly.

Thanks
samh22a
Service Provider
 
Posts: 35
Liked: 2 times
Joined: Sun Nov 10, 2013 2:03 pm


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 12 guests