Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
rene@aksessikt.no
Influencer
Posts: 12
Liked: never
Joined: Mar 27, 2011 5:48 pm
Full Name: Rene van Veen
Contact:

Backup of SQL Always on Cluster

Post by rene@aksessikt.no » Aug 15, 2019 9:39 am

Hi You'll

I've sett up a backup job of a AO SQL cluster. I followed documentation and everything went smooth.
Backup job runs well and backup copy works to.
I get just one warning, doesn't seem dangerous but I don't like unsolved warnings :-)
It says that on my secondary node the job is unable to truncate the logs. I've been searching and found some good post's but non seem to answer my question.
I read it like that it's normal that the secondary node log isn't truncated, no problem but way is it trying? can I exclude it from the secondary node? Are the logs on the secondary node truncated in any way?
My setup is to virtualized windows 2016 servers that run inside a Hyper-V cluster I use SQL 2017 or version nr 14.0.2027.2

I greatly appreciate any comments that sheds some light

Regards Rene

nmdange
Expert
Posts: 456
Liked: 105 times
Joined: Aug 20, 2015 9:30 pm
Contact:

Re: Backup of SQL Always on Cluster

Post by nmdange » Aug 15, 2019 4:40 pm

Are you on the latest patch for Veeam? This was an issue but it should be fixed now, at least I haven't seen any warnings anymore on 9.5 U4b
veeam-backup-replication-f2/backup-sql- ... 92-30.html

rene@aksessikt.no
Influencer
Posts: 12
Liked: never
Joined: Mar 27, 2011 5:48 pm
Full Name: Rene van Veen
Contact:

Re: Backup of SQL Always on Cluster

Post by rene@aksessikt.no » Aug 16, 2019 11:31 am

Hi thx for your reply. it seems I'm using the latest yhat's not Beta my version is 9.5.4.2866
i think the logical cause for the warning is that the secondary node is read only.
Just checked it again Node 1 my primary is successful.
In the setup I followed VEEAM's manual and it shows up as a Windows Agent Backup
There must be a way to suppress this warning, hope there's a VEEAM engineer monitoring this thread.

Regards Rene

foggy
Veeam Software
Posts: 18027
Liked: 1531 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL Always on Cluster

Post by foggy » Aug 16, 2019 3:29 pm

Hi Rene, are we talking about Basic Availability Groups? Also, you are mentioning "Windows Agent Backup" but you're using Veeam B&R 9.5.4.2866 to backup the SQL cluster, right?

rene@aksessikt.no
Influencer
Posts: 12
Liked: never
Joined: Mar 27, 2011 5:48 pm
Full Name: Rene van Veen
Contact:

Re: Backup of SQL Always on Cluster

Post by rene@aksessikt.no » Aug 17, 2019 5:21 pm

Yes this is a basic availibilty group with to SQL servers as a member. SQL is installed on a virtualized windows 2016 server that's setup as a 2 server cluster.
I just followed the instructions I found from VEEAM. There it said I had to creat an AD protection group, both servers are part. It automatically installed the windows Agents. And yes I use VEEAM B&R a 6 processor licens

foggy
Veeam Software
Posts: 18027
Liked: 1531 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL Always on Cluster

Post by foggy » Aug 18, 2019 6:00 pm

Seems you're mixing up two products here. You do not need Veeam Agent for Windows in this setup, you can back up these virtual SQL servers using Veeam B&R.

rene@aksessikt.no
Influencer
Posts: 12
Liked: never
Joined: Mar 27, 2011 5:48 pm
Full Name: Rene van Veen
Contact:

Re: Backup of SQL Always on Cluster

Post by rene@aksessikt.no » Aug 19, 2019 6:28 am

THX i was afraid I did but it said so in the manual VEEAM made for this and it installed the agents from inside VEEAM B&R it was no choice i made or an installation I did separate.
The manual told med to add an AD protection Group under Physical Cloud Infrastructure. There I added my MS cluster object (that has 2 nodes) When I get to Options it asks me to pic a distribution server and has tagged Install backup agents and auto update. After i said I was happy and clicked apply it installed the agents on my Nodes.
And as i said it works it's just annoying that on my secondary node it gives a warning that it cant purge the SQL logs (which is not possible since they're read only.

BTW this is the KB or Manual I used https://www.veeam.com/kb2463

if you can plz point me to the right KB or documentation so I can correct my error.
Regards Rene

rene@aksessikt.no
Influencer
Posts: 12
Liked: never
Joined: Mar 27, 2011 5:48 pm
Full Name: Rene van Veen
Contact:

Re: Backup of SQL Always on Cluster

Post by rene@aksessikt.no » Aug 19, 2019 6:33 am

Hi Foggy.

just found some more articles veeam-backup-replication-f2/backup-sql- ... 40892.html
Seems that this a know issue that VEEAM will address in V10 or did I interpret the article wrong?

regards Rene

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests