Backing up Always On MSSQL with Veeam

Availability for the Always-On Enterprise

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Fri Apr 11, 2014 8:05 pm

Yes, it should. Triggering a VSS snapshot manually is a good idea!
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 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 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?
lightsout
Expert
 
Posts: 186
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 9:48 pm

Let me get more details from our dev team next week. I will update the thread after that.
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby imdo » Wed 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.
imdo
Lurker
 
Posts: 2
Liked: never
Joined: Mon Jan 28, 2013 2:32 pm
Full Name: N.A

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Wed May 14, 2014 7:08 pm

Hello, currently you can backup the VMs in crash-consistent way only. Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby imdo » Thu May 15, 2014 7:35 am

Don't you mean non-crash consistent?
imdo
Lurker
 
Posts: 2
Liked: never
Joined: Mon Jan 28, 2013 2:32 pm
Full Name: N.A

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby v.Eremin » Thu 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.
v.Eremin
Veeam Software
 
Posts: 13433
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

[MERGED] : SQL Availability Groups

Veeam Logoby nholman » Tue 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
nholman
Enthusiast
 
Posts: 57
Liked: 5 times
Joined: Wed Nov 28, 2012 10:23 am
Full Name: Nick Holman

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13433
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby nholman » Tue 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
nholman
Enthusiast
 
Posts: 57
Liked: 5 times
Joined: Wed Nov 28, 2012 10:23 am
Full Name: Nick Holman

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13433
Liked: 987 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

[MERGED] Support for Veeam Replication a SQL 2012 Cluster

Veeam Logoby aetius80 » Thu 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
aetius80
Novice
 
Posts: 4
Liked: never
Joined: Thu May 29, 2014 2:55 pm
Full Name: aetius mailman

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby foggy » Thu May 29, 2014 8:13 pm

Please review the thread above for details.
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED]Does Veeam 6.5 support replicating a SQL AlwaysOn

Veeam Logoby agentpineapple » Fri 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
agentpineapple
Lurker
 
Posts: 2
Liked: never
Joined: Fri May 30, 2014 8:08 am
Full Name: dan bha

Re: Backing up Always On MSSQL with Veeam

Veeam Logoby Vitaliy S. » Fri May 30, 2014 8:38 am

Please check out this thread for the answer. If you still need any clarifications, please let us know.
Vitaliy S.
Veeam Software
 
Posts: 19709
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

PreviousNext

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot] and 16 guests