Agent-based backup of Windows, Linux, Max, AIX and Solaris machines.
Post Reply
aschalk
Enthusiast
Posts: 31
Liked: 1 time
Joined: Sep 07, 2016 5:47 am
Contact:

Backup for SQL Always On 2012

Post by aschalk »

It was great news that the Veeam Agent for Windows it now supporting SQL Always on.
I would like to give this a try but the information on this in the user guide is nearing zero.

I have a B&R Server which will manage the backup Job.
The two SQL nodes are already members of their own protection group (Agent + CBT installed)

If possible I would like to do

- Transaction Log Backup every 30 minutes
- Incremental Backup every 4 hours
- Full Backup once per day at midnight.

How can I achieve this?
aschalk
Enthusiast
Posts: 31
Liked: 1 time
Joined: Sep 07, 2016 5:47 am
Contact:

Re: Backup for SQL Always On 2012

Post by aschalk »

Update:

I tried to backup but the job will fail immediately with the message that both hosts are not part of failover cluster which they are.
aschalk
Enthusiast
Posts: 31
Liked: 1 time
Joined: Sep 07, 2016 5:47 am
Contact:

Re: Backup for SQL Always On 2012

Post by aschalk »

Found the solution

Image

Above option has to be left unselected then discovery of the cluster nodes will work.
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backup for SQL Always On 2012

Post by Mike Resseler »

Hi Aschalk,

It seems a bit strange to me that this setting did the trick. In the end, I assume that your SQL server is running and is not offline.
I know it works now, but it would be great if you could create a support call for this with the explanation. It feels to me like something is not correct here. Post the support case ID here and let us know the outcome after investigation of the engineers.

Again, I can be mistaken but it seems to make no sense to me.

I am looking at the same time through the documentation, and I think you are right. There is limited information so I will discuss this with the PM for VAW and see if we can improve it from our side.

Last but not least, seeing the options above, those SQL boxes are physical right?
aschalk
Enthusiast
Posts: 31
Liked: 1 time
Joined: Sep 07, 2016 5:47 am
Contact:

Re: Backup for SQL Always On 2012

Post by aschalk »

Hey Mike,

Thanks for our answers.

Yep, seems strange because this cluster is in use 24/7. I will submit a support call.

You are correct, both nodes are physical.
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Backup for SQL Always On 2012

Post by Dima P. »

aschalk,

Please do not forget to share the case ID. I'll ask our QA team to check your logs. Thank you in advance.
aschalk
Enthusiast
Posts: 31
Liked: 1 time
Joined: Sep 07, 2016 5:47 am
Contact:

Re: Backup for SQL Always On 2012

Post by aschalk »

Hey Dima,

ID# 02464223 is the ID of the call.
Kn0rki
Novice
Posts: 3
Liked: never
Joined: Jan 10, 2015 1:32 am
Contact:

Re: Backup for SQL Always On 2012

Post by Kn0rki »

hi folks,

i got this error too.
i removed both cluster nodes and added the cluster resource from Active Directory.
Now it works!
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Backup for SQL Always On 2012

Post by Dima P. »

Hello Kn0rki,

Thank you for your post! Indeed, Cluster Account should be added via Active Directory protection group instead of standalone nodes (otherwise it’s impossible to configure failover cluster job).
Post Reply

Who is online

Users browsing this forum: Robert-xl and 8 guests