Backing up Always On MSSQL with Veeam

Availability for the Always-On Enterprise

Backing up Always On MSSQL with Veeam

Veeam Logoby ICarter » Fri Sep 13, 2013 10:51 am

Hi all,

We're looking at future options for our MSSQL servers and we are considering using a Always On SQL cluster. The advantage of this is that it doesn't use shared disk and so doesn't need a RDM which obviously Veeam can't protect. Given that in theory Veeam should be able to protected a MSSQL Always On cluster, I'm wondering if anyone has actually tried it, or if we'll be the first? :)

Cheers, Ian
ICarter
Novice
 
Posts: 9
Liked: never
Joined: Mon Apr 15, 2013 3:37 pm
Full Name: Ian Carter

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Fri Sep 13, 2013 12:00 pm

Hi Ian,

As far as I know there were some kind of issues when backing up SQL Server passive node. If you have all active DB copies on one node and passive DB copies on the other, then based on the support team experience you should be able to backup the node holding active copies of your databases.

Hope this helps!
Vitaliy S.
Veeam Software
 
Posts: 19469
Liked: 1092 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

[MERGED] sql 2012 always on groups

Veeam Logoby phillbl » Fri Sep 20, 2013 5:16 am

hi,
does veeam B&R support backing up the second sql server in an always on group? the second server being a readable seconday.

i am backing up two new servers. first sql server works a treat and the 2nd has the following error
20/09/2013 12:23:55 PM :: Unable to release guest. Error: Unfreeze error: [Backup job failed.
Cannot create a shadow copy of the volumes containing writer's data.
A VSS critical writer has failed. Writer name: [SqlServerWriter]. Class ID: [{a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}]. Instance ID: [{d6e49bd2-839a-4040-8ea2-be4edc14f5ad}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].]
the servers are new and multliple other servers in this new environment built from the same template on vmware. this is the only one with an error.
thanks
phillbl
Enthusiast
 
Posts: 37
Liked: 5 times
Joined: Wed Jul 17, 2013 1:57 am
Full Name: phill

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby schenkewitz » Fri Nov 22, 2013 7:48 pm

We encountered the same error.

We're having an 5 node Microsoft SQL 2012 Enterprise - AlwaysOn Availability Group and and only the first node with the active db's can be backed up with Veeam. The other 4 nodes (all readable secondaries) cannot be backed up.

Is there any solution for this problem? We would like to backup all nodes of this availability group.
CTO @ www.mgn-computing.de

Managed Infrastructure Hosting | Hosted Exchange, SharePoint, Lync, CRM | Hosted MailArchive | VDI | Veeam Cloud Connect
on VMware vCloud Architecture in DE, FR, NL, UK

- www.procloud.de -
schenkewitz
Service Provider
 
Posts: 13
Liked: 6 times
Joined: Fri Nov 22, 2013 7:35 pm
Location: Nürnberg, Germany
Full Name: Christian Schenkewitz

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Sun Nov 24, 2013 8:48 pm

I don't think there was a solution (at least I cannot find it), but you can double-check that by opening a support case with our technical team.
Vitaliy S.
Veeam Software
 
Posts: 19469
Liked: 1092 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Wolfraider » Sat Nov 30, 2013 4:21 pm

We had a case open with support. You can only backup your active nodes at this time due to an issue with the Microsoft SQL VSS writer. They are looking at fixing this in a future update but no timeline yet.
Wolfraider
Novice
 
Posts: 3
Liked: 1 time
Joined: Sat Nov 30, 2013 3:43 pm
Full Name: Travis Garrison

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby ermer » Wed Mar 19, 2014 12:41 pm

Any update to this? We are currently implementing an Always On cluster and can only backup the primary replica node as well.
ermer
Novice
 
Posts: 7
Liked: never
Joined: Tue Mar 18, 2014 12:31 pm
Location: Buffalo, NY
Full Name: Ermer

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Wed Mar 19, 2014 3:43 pm

There were no updates on this yet.
Vitaliy S.
Veeam Software
 
Posts: 19469
Liked: 1092 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby darryl.crossley » Tue Apr 01, 2014 2:56 am

I'm having some major issues with SQL Always-on and Application-Aware Image Processing.

The workaround I've been told is to disable application-aware image processing and create crash consistent backups instead via VMware Tools, this isn't a valid solution.

The customer presently runs multiple availability groups which are load balanced to be active and passive across different nodes, therefore one node can be active for one AG and passive for another AG.

Case # 00538082

Help!
darryl.crossley
Enthusiast
 
Posts: 48
Liked: 5 times
Joined: Wed Oct 03, 2012 1:18 am
Full Name: Darryl Crossley

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Tue Apr 01, 2014 9:56 am

Darryl, I don't think there were any changes yet on how to backup MSSQL with Always-On option...
Vitaliy S.
Veeam Software
 
Posts: 19469
Liked: 1092 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby darryl.crossley » Tue Apr 01, 2014 10:34 pm

Have we got a best practise workaround in place? If so, I need a detailed plan and validation as to why we're struggling here.
darryl.crossley
Enthusiast
 
Posts: 48
Liked: 5 times
Joined: Wed Oct 03, 2012 1:18 am
Full Name: Darryl Crossley

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Gostev » Wed Apr 02, 2014 8:57 am

Backing up Always On MSSQL with Veeam is currently not supported, other than in crash-consistent mode.
Gostev
Veeam Software
 
Posts: 21364
Liked: 2336 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Anton Gostev

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby lightsout » Thu Apr 10, 2014 4:27 pm

I've got the same issue as well. Do we have any ETA as to when it will be supported? Is this a Veeam issue or a problem with the Microsoft VSS provider?
lightsout
Expert
 
Posts: 183
Liked: 47 times
Joined: Thu Apr 10, 2014 4:13 pm

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Fri Apr 11, 2014 10:48 am

Since this error message is returned by the VSS writer, I assume it is more a Microsoft-related problem. We are still investigating possible ways of backing it up, but there is no ETA yet.
Vitaliy S.
Veeam Software
 
Posts: 19469
Liked: 1092 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby lightsout » Fri Apr 11, 2014 5:47 pm

Would a ticket with Microsoft help? As I imagine we can trigger this issue directly in Windows by triggering VSS to run regardless of Veeam's presence.
lightsout
Expert
 
Posts: 183
Liked: 47 times
Joined: Thu Apr 10, 2014 4:13 pm

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], foggy, Google Feedfetcher, hasayeretFMG, opg70 and 67 guests