Is VAEEM support SQL/Windows cluster on Hyper-v .

Hyper-V specific discussions

Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Someonenew2014 » Wed Feb 04, 2015 8:35 pm

Hi ,

I wonder whether SQL cluster on hyper-v (2012 both) supported on VAEEM backup. if not, is it possible to back it and restore ? limitation ?!!!

I would like to know this type of information? any input would be appreciated.


Thank you.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby alanbolte » Thu Feb 05, 2015 7:18 am

SQL offers a number of clustering options. Please be more specific about your configuration.
alanbolte
Expert
 
Posts: 635
Liked: 170 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Someonenew2014 » Thu Feb 05, 2015 7:25 pm

Hi..

Yes we have SQL running on windows cluster 2012. Running on Hyper-v 2012 R2. The Hyper-V admin use VHDX instead of pass-through. Current version is 8.


I hope this help
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby alanbolte » Fri Feb 06, 2015 2:10 am

Do you mean the cluster uses shared VHDX, as opposed to replicating the database between separate VHDX? Shared VHDX is supported starting in version 8, but will only back up in a crash-consistent state.
alanbolte
Expert
 
Posts: 635
Liked: 170 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Someonenew2014 » Sat Feb 07, 2015 3:48 am

Thanks. Yes it is a shared VHDX. Please elaborate on crash-consistent state
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby foggy » Sat Feb 07, 2015 9:27 am

Please review this user guide section.
foggy
Veeam Software
 
Posts: 14743
Liked: 1081 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Someonenew2014 » Wed Mar 25, 2015 6:10 am

Thanks. pls correct me, in the same configuration i'm using (Shared VHDX running on Hyper-V 2012 , on top of that SQL server 2012)

If I take a backup of this VM that is a clustered and running Hyper-V with Application-Aware Image Processing option selected. Is that mean data integrity cannot be preserved?
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby v.Eremin » Wed Mar 25, 2015 9:58 am

Machines residing on shared VHDX will be backed up in crash-consistent mode.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 969 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby foggy » Wed Mar 25, 2015 9:59 am

Such backup will be similar to the VM state after a system failure or power outage. Typically, SQL Server is able to successfully recover from crash-consistent backup, so having at least crash-consistent backup is better than having no backup at all.
foggy
Veeam Software
 
Posts: 14743
Liked: 1081 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Someonenew2014 » Fri Mar 27, 2015 6:30 pm

Thanks foggy.

So, I have concern of SQL data will VAEEM should be enough to backup SQL server in this case or should I use a complementary solution like Maintenance plan for Backup databases.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Gostev » Sun Mar 29, 2015 12:02 am

Veeam backup that is tested for recoverability with SureBackup is enough.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby nefes » Mon Mar 30, 2015 2:59 pm

SureBackup skips shared vhdx disks, so it will not help to check such backups.
nefes
Veeam Software
 
Posts: 534
Liked: 125 times
Joined: Mon Dec 10, 2012 8:44 am
Full Name: Nikita Efes

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Someonenew2014 » Thu Apr 02, 2015 7:47 pm

So how can test the shared VHDX backup.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Is VAEEM support SQL/Windows cluster on Hyper-v .

Veeam Logoby Vitaliy S. » Sun Apr 05, 2015 3:18 pm

As far as I see from internal notes for this feature, the only way to currently do that is to do a restore manually.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1102 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: Bing [Bot], PTide and 12 guests