Backing up Always On MSSQL with Veeam

Availability for the Always-On Enterprise

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby agentpineapple » Fri 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
agentpineapple
Lurker
 
Posts: 2
Liked: never
Joined: Fri May 30, 2014 8:08 am
Full Name: dan bha

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Fri 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.
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby v.Eremin » Fri 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.
v.Eremin
Veeam Software
 
Posts: 13433
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Gostev » Fri 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.
Gostev
Veeam Software
 
Posts: 21442
Liked: 2362 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Alek14 » Wed 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
Alek14
Novice
 
Posts: 4
Liked: never
Joined: Wed Jun 04, 2014 10:52 pm

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby foggy » Thu Jun 05, 2014 9:25 am

Alek, shared VHDX disks are currently not supported for backup by Microsoft, and hence automatically excluded from backup.
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Alek14 » Thu Jun 05, 2014 9:55 pm

Ok...so how do I effectively backup an SQL DB (AlwaysOn) then? thanks
Alek14
Novice
 
Posts: 4
Liked: never
Joined: Wed Jun 04, 2014 10:52 pm

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Gostev » Thu 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.
Gostev
Veeam Software
 
Posts: 21442
Liked: 2362 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby mdornfeld » Fri 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.
mdornfeld
Expert
 
Posts: 125
Liked: 2 times
Joined: Mon Mar 23, 2009 4:44 pm
Full Name: Matt

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby v.Eremin » Sat 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.
v.Eremin
Veeam Software
 
Posts: 13433
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby lightsout » Mon 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.
lightsout
Expert
 
Posts: 186
Liked: 47 times
Joined: Thu Apr 10, 2014 4:13 pm

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby enettekoven » Sat 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?
enettekoven
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 21, 2013 2:02 pm
Full Name: Erik Nettekoven

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Sun 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!
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby enettekoven » Mon 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?
enettekoven
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 21, 2013 2:02 pm
Full Name: Erik Nettekoven

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Mon 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!
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

PreviousNext

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: anthonyspiteri79 and 17 guests