Availability for the Always-On Enterprise
Post Reply
ICarter
Novice
Posts: 9
Liked: never
Joined: Apr 15, 2013 3:37 pm
Full Name: Ian Carter
Contact:

Backing up Always On MSSQL with Veeam

Post by ICarter » 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

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. » 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!

phillbl
Enthusiast
Posts: 37
Liked: 5 times
Joined: Jul 17, 2013 1:57 am
Full Name: phill
Contact:

[MERGED] sql 2012 always on groups

Post by phillbl » 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

schenkewitz
Service Provider
Posts: 13
Liked: 6 times
Joined: Nov 22, 2013 7:35 pm
Full Name: Christian Schenkewitz
Location: Nürnberg, Germany
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by schenkewitz » 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 -

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. » 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.

Wolfraider
Novice
Posts: 3
Liked: 1 time
Joined: Nov 30, 2013 3:43 pm
Full Name: Travis Garrison
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by Wolfraider » 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.

ermer
Novice
Posts: 7
Liked: never
Joined: Mar 18, 2014 12:31 pm
Full Name: Ermer
Location: Buffalo, NY
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by ermer » 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.

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. » Mar 19, 2014 3:43 pm

There were no updates on this yet.

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

Re: Backing up Always On MSSQL with Veeam

Post by darryl.crossley » 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!

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. » 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...

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

Re: Backing up Always On MSSQL with Veeam

Post by darryl.crossley » 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.

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 » Apr 02, 2014 8:57 am

Backing up Always On MSSQL with Veeam is currently not supported, other than in crash-consistent mode.

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 » 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?

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. » 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.

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 » 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.

Post Reply

Who is online

Users browsing this forum: nitr0d and 49 guests