Availability for the Always-On Enterprise
Post Reply
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 8:05 pm

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

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

v.Eremin
Veeam Software
Posts: 15209
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

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

v.Eremin
Veeam Software
Posts: 15209
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

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

v.Eremin
Veeam Software
Posts: 15209
Liked: 1146 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up Always On MSSQL with Veeam

Post by v.Eremin » 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
Contact:

[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: 16932
Liked: 1377 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.
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. » 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: nitr0d and 46 guests