Comprehensive data protection for all workloads
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.
Product Manager
Posts: 23067
Liked: 1582 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.
Product Manager
Posts: 23067
Liked: 1582 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.
Product Manager
Posts: 23067
Liked: 1582 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.
Product Manager
Posts: 23067
Liked: 1582 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
SVP, Product Management
Posts: 24929
Liked: 3620 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: 218
Liked: 58 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.
Product Manager
Posts: 23067
Liked: 1582 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: 218
Liked: 58 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.

Vitaliy S.
Product Manager
Posts: 23067
Liked: 1582 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 8:05 pm

Yes, it should. Triggering a VSS snapshot manually is a good idea!

lightsout
Expert
Posts: 218
Liked: 58 times
Joined: Apr 10, 2014 4:13 pm
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by lightsout » Apr 11, 2014 9:26 pm

I tried to use vssadmin to create a snasphot, but it worked just fine for both drives. Is there some other method for trigger a SQL VSS?

Vitaliy S.
Product Manager
Posts: 23067
Liked: 1582 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 9:48 pm

Let me get more details from our dev team next week. I will update the thread after that.

imdo
Lurker
Posts: 2
Liked: never
Joined: Jan 28, 2013 2:32 pm
Full Name: N.A
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by imdo » May 14, 2014 2:52 pm

Vitaliy S. wrote:Let me get more details from our dev team next week. I will update the thread after that.
Hi is there any news on this yet? We're experiencing the same issue, but only on a handful of availability group nodes. Backing up a single node doesn't work well for us as we split two application database sets between two severs so both nodes are acting as an active and passive for different applications.

Vitaliy S.
Product Manager
Posts: 23067
Liked: 1582 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 14, 2014 7:08 pm

Hello, currently you can backup the VMs in crash-consistent way only. Thanks!

imdo
Lurker
Posts: 2
Liked: never
Joined: Jan 28, 2013 2:32 pm
Full Name: N.A
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by imdo » May 15, 2014 7:35 am

Don't you mean non-crash consistent?

veremin
Product Manager
Posts: 17000
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by veremin » May 15, 2014 9:18 am

A small correction - we can't backup VMs that host, at least, one passive replica. If VMs hosts only active replicas, there will be no issues.

As to a workaround for VMs hosting passive replicas, you can use trigger PS script that failovers SQL passive replicas to active ones, executes job, and fails replicas back. Being executed outside of production window, the script should do the trick.

Thanks.

nholman
Enthusiast
Posts: 60
Liked: 5 times
Joined: Nov 28, 2012 10:23 am
Full Name: Nick Holman
Contact:

[MERGED] : SQL Availability Groups

Post by nholman » May 27, 2014 9:44 am

Hi All

Does the latest version of Veeam (7) support the backing up of a 2 Node SQL 2012 availability group (active db / passive db)? are there any limitations or requirements?

If there are issues, will version 8 bring new support to this?
appreciate some guidance on this.

Thanks

veremin
Product Manager
Posts: 17000
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by veremin » May 27, 2014 10:19 am

Hi, Nick,

Your post has been merged into existing discussion regarding backup of Always On MSSQL. Please, see answers provided above, and ask for additional clarification, if needed.

Thanks.

nholman
Enthusiast
Posts: 60
Liked: 5 times
Joined: Nov 28, 2012 10:23 am
Full Name: Nick Holman
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by nholman » May 27, 2014 10:47 am

v.Eremin wrote:Hi, Nick,

Your post has been merged into existing discussion regarding backup of Always On MSSQL. Please, see answers provided above, and ask for additional clarification, if needed.

Thanks.

Thanks for letting me know - the questions still stands i think

veremin
Product Manager
Posts: 17000
Liked: 1455 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by veremin » May 27, 2014 10:59 am

The answer provided above seems to cover the questions regarding existing limitations and the way to bypass those.

As to v8 feature set, I can't comment on it at the moment. Some of the features have been already announced, the more are coming. Kindly, use the v8 landing page as the source of most up-to-date information (you can sign up for updates there). Stay tuned!

Thanks.

aetius80
Novice
Posts: 4
Liked: never
Joined: May 29, 2014 2:55 pm
Full Name: aetius mailman

[MERGED] Support for Veeam Replication a SQL 2012 Cluster

Post by aetius80 » May 29, 2014 3:01 pm

Hi,

Does Veam support asynchronous replication of Windows 2012 2 node clusters without shared storage? I'm looking at creating an AlwaysOn Availability group in my main DC and having a replica copy at the secondary DC, but am not sure whether Veam supports replication of Microsoft shared clusters which do not use shared storage.

Thanks

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

Re: Backing up Always On MSSQL with Veeam

Post by foggy » May 29, 2014 8:13 pm

Please review the thread above for details.

agentpineapple
Lurker
Posts: 2
Liked: never
Joined: May 30, 2014 8:08 am
Full Name: dan bha
Contact:

[MERGED]Does Veeam 6.5 support replicating a SQL AlwaysOn

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

Hi,
I have VMware 5.1 and am using Veam 6.5. We're looking to replicate a SQL AlwayOn Database Availability Group from over the WAN from our main DC to a DR site. I'm using Windows 2012 and SQL 2012 AlwaysOn Database Availability Groups without shared storage - is this supported by Veam?

Thanks

Vitaliy S.
Product Manager
Posts: 23067
Liked: 1582 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:38 am

Please check out this thread for the answer. If you still need any clarifications, please let us know.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 23 guests