Veeam Agent for Windows SQL Cluster

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

Veeam Agent for Windows SQL Cluster

Veeam Logoby bhildebrand1 » Wed May 17, 2017 7:57 pm

Is it possible to use the Veeam Agent for Windows on physical SQL server that is clustered? I have attempted and failed and from what I can see is it never asks for the SQL server name(which would be different than the server name since it is clustered).

Any thoughts?
bhildebrand1
Lurker
 
Posts: 2
Liked: never
Joined: Wed May 17, 2017 7:53 pm
Full Name: Brian Hildebrand

Re: Veeam Agent for Windows SQL Cluster

Veeam Logoby jmmarton » Thu May 18, 2017 4:20 am

We support SQL AlwaysOn Availability Groups but not SQL running on Windows Failover Cluster. However, today at VeeamON we announced future support for Failover Cluster.

Joe
jmmarton
Veeam Software
 
Posts: 1146
Liked: 123 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: Veeam Agent for Windows SQL Cluster

Veeam Logoby bhildebrand1 » Thu May 18, 2017 12:48 pm

Thank you for your quick answer and that is great that you will have future support.

Until then let me ask this. If I have a physical server that is the active node of the cluster and I perform a full backup, it looks like it grabs all drives even if those drives are part of the windows cluster. If that is the case is it possible to take that full backup(of the physical server) and restore it to a VM and have all of the drives be created as well? I did an initial test and it looked like only the OS drive was there on the VM but I was expecting to see all drives.

Thanks again!
bhildebrand1
Lurker
 
Posts: 2
Liked: never
Joined: Wed May 17, 2017 7:53 pm
Full Name: Brian Hildebrand

Re: Veeam Agent for Windows SQL Cluster

Veeam Logoby Dima P. » Wed May 24, 2017 3:50 am 1 person likes this post

Hi Brian,

Joe was not correct. Today VAW does not support clusters and SQL AlwaysOn. Sorry for confusion and any inconvenience caused.
Dima P.
Veeam Software
 
Posts: 7831
Liked: 563 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: Prague
Full Name: Dmitry Popov

Re: Veeam Agent for Windows SQL Cluster

Veeam Logoby jmmarton » Wed May 24, 2017 9:18 pm

My apologies--I was thinking about VBR and not VAW regarding SQL AlwaysOn.

Joe
jmmarton
Veeam Software
 
Posts: 1146
Liked: 123 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: Veeam Agent for Windows SQL Cluster

Veeam Logoby davis_b » Tue Feb 27, 2018 10:37 pm

In recent weeks our DBA's have started looking into Availability groups for SQL. Since configuring a couple of SQL servers with an Availability Group my Veeam backups have been failing on the secondary replica with the following error found in the event viewer:

Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 976
Error state: 1, Severity: 14
Source: Microsoft SQL Server Native Client 11.0
Error message: The target database, 'DBNAME', is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability replicas in the group. For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.

I am NOT backing up SQL via the Veeam agent with application-aware processing. I am simply backing up the whole server via a file level backup - the DBA's just dump a SQL backup file to the file system and Veeam picks up that DB backup along with the rest of the file system nightly.

Anyone ran into this issue, and how did you resolve it?
davis_b
Influencer
 
Posts: 11
Liked: never
Joined: Tue Jan 03, 2017 3:11 pm
Full Name: Brent Davis

Re: Veeam Agent for Windows SQL Cluster

Veeam Logoby JLundgren » Mon Mar 12, 2018 10:03 pm

Hello,

does VAW support SQL Failover clusters where destination is a SP (VCC-B) ?

Where can I find more information about this ?

Regards,

JLundgren
JLundgren
Service Provider
 
Posts: 54
Liked: 3 times
Joined: Fri Nov 13, 2015 10:00 am
Full Name: Johnny Lundgren


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: Bing [Bot] and 6 guests