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