Availability for the Always-On Enterprise
Post Reply
agentpineapple
Lurker
Posts: 2
Liked: never
Joined: May 30, 2014 8:08 am
Full Name: dan bha
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by agentpineapple » May 30, 2014 8:43 am

Hi Vitaly,

So reading the thread, Veam supports backing up the active node in a SQL always on cluster?

But does Veam also support replication of the node?

Thanks

Vitaliy S.
Veeam Software
Posts: 21612
Liked: 1290 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Vitaliy S. » May 30, 2014 8:51 am

Hi Dan, you can either backup and replicate these VMs with application-aware image processing option disabled or if you have only active database present on the VM, you can enable this option in the jobs.

v.Eremin
Veeam Software
Posts: 15209
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by v.Eremin » May 30, 2014 8:57 am

And to backup VMs hosting passive replicas some of our customers leverages the following workaround outside production hours:

1) Create a script that turns passive node into active one, performing manual failover.
2) Execute a backup job.
3) Once the snapshot is taken, reverts everything back.

Thanks.

Gostev
Veeam Software
Posts: 23100
Liked: 2913 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Gostev » May 30, 2014 9:36 pm 2 people like this post

Just wanted to add that we are working on adding native support for application-aware backup of AlwaysOn SQL servers without the need to use scripts. Thanks everyone for providing your feedback, this helped to raise the priority of this feature.

Alek14
Novice
Posts: 4
Liked: never
Joined: Jun 04, 2014 10:52 pm
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Alek14 » Jun 04, 2014 11:05 pm

Hi,

I'm new to Veeam product.
I'm trying to backup AlwaysOn SQL and followed advise above to make the backup of Passive Node. The backup runs fine but I'm seeing that Data and Log Drives which are shared VHDX are being excluded. As these are the drives I really need backing up I'm wondering if I'm missing something here?

Thanks,

Alek

foggy
Veeam Software
Posts: 16932
Liked: 1377 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by foggy » Jun 05, 2014 9:25 am

Alek, shared VHDX disks are currently not supported for backup by Microsoft, and hence automatically excluded from backup.

Alek14
Novice
Posts: 4
Liked: never
Joined: Jun 04, 2014 10:52 pm
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Alek14 » Jun 05, 2014 9:55 pm

Ok...so how do I effectively backup an SQL DB (AlwaysOn) then? thanks

Gostev
Veeam Software
Posts: 23100
Liked: 2913 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Gostev » Jun 05, 2014 11:17 pm

I am afraid there is nothing you can do until Microsoft adds support for backing up shared VHDX. A lot of people are frustrated with this limitation, since obviously lack of backup turns this whole shared VHDX feature into unusable gimmick, so I am sure this feature is a priority for Microsoft.

mdornfeld
Expert
Posts: 125
Liked: 2 times
Joined: Mar 23, 2009 4:44 pm
Full Name: Matt
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by mdornfeld » Jun 13, 2014 2:39 pm

Add me to the list of people who are very interested in some kind of Best Practice whitepaper or KB article on how to correctly backup SQL 2012 Always-On clusters on the VMware platform using Veeam. I did open a case #00582605 to request the same directly from Veeam support as well. Thanks.

v.Eremin
Veeam Software
Posts: 15209
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by v.Eremin » Jun 14, 2014 9:55 am 1 person likes this post

As mentioned above, we're working on adding native support for Always On SQL. Chances are, sooner rather than later there will be no need in KB article, as everything will be done automatically by Application Aware Image Processing. Thanks.

lightsout
Expert
Posts: 208
Liked: 54 times
Joined: Apr 10, 2014 4:13 pm
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by lightsout » Jun 16, 2014 1:28 pm

I actually have my vCenter DB on the Always On cluster too. Veeam correctly identifies that it is the VMware DB, however, it uses the name of the listener rather than the name of the VM. So I had to do this:

http://www.veeam.com/kb1051

To allow me to backup the active node again.

enettekoven
Novice
Posts: 5
Liked: never
Joined: Nov 21, 2013 2:02 pm
Full Name: Erik Nettekoven
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by enettekoven » Jun 21, 2014 3:12 pm

I am having the exact same issue. In our situation the AlwaysOn SQL is used to host the SharePoint Databases. As soon as there is an update, will that be posted here or is there some other way to be kept in this/the loop?

Vitaliy S.
Veeam Software
Posts: 21612
Liked: 1290 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Vitaliy S. » Jun 22, 2014 11:59 am

Yes, you can either subscribe to these forums or check our What's New document that is always shipped with our updates/releases. Thanks!

enettekoven
Novice
Posts: 5
Liked: never
Joined: Nov 21, 2013 2:02 pm
Full Name: Erik Nettekoven
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by enettekoven » Jun 23, 2014 8:10 am

This topic only describes the backup of the alwaysOn, how about the restore especially when hosting SharePoint DB's and trying to use the Veeam Explorer for SharePoint?

Vitaliy S.
Veeam Software
Posts: 21612
Liked: 1290 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Vitaliy S. » Jun 23, 2014 3:37 pm

Hi Erik,

Can you please clarify your question? Do you see issues with using Explorer for SharePoint and Always-On SQL Server databases?

Thanks!

Post Reply

Who is online

Users browsing this forum: nitr0d and 56 guests