Host-based backup of Microsoft Hyper-V VMs.
Post Reply
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

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

Post by Someonenew2014 »

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.
alanbolte
Veteran
Posts: 635
Liked: 174 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

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

Post by alanbolte »

SQL offers a number of clustering options. Please be more specific about your configuration.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

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

Post by Someonenew2014 »

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
alanbolte
Veteran
Posts: 635
Liked: 174 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

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

Post by alanbolte »

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.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

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

Post by Someonenew2014 »

Thanks. Yes it is a shared VHDX. Please elaborate on crash-consistent state
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

Please review this user guide section.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

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

Post by Someonenew2014 »

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?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin »

Machines residing on shared VHDX will be backed up in crash-consistent mode.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

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.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

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

Post by Someonenew2014 »

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.
Gostev
Chief Product Officer
Posts: 31460
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

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

Post by Gostev »

Veeam backup that is tested for recoverability with SureBackup is enough.
nefes
Veeam Software
Posts: 643
Liked: 162 times
Joined: Dec 10, 2012 8:44 am
Full Name: Nikita Efes
Contact:

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

Post by nefes »

SureBackup skips shared vhdx disks, so it will not help to check such backups.
Someonenew2014
Enthusiast
Posts: 58
Liked: 3 times
Joined: Feb 04, 2015 8:25 pm

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

Post by Someonenew2014 »

So how can test the shared VHDX backup.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

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

Post by Vitaliy S. »

As far as I see from internal notes for this feature, the only way to currently do that is to do a restore manually.
Post Reply

Who is online

Users browsing this forum: No registered users and 31 guests