Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
bjdboyer
Enthusiast
Posts: 43
Liked: 2 times
Joined: Nov 16, 2015 5:52 pm
Full Name: Bill Boyer
Contact:

Physical SQL Server Cluster Backup Recommendations

Post by bjdboyer » Nov 03, 2016 6:49 pm

Got a new customer moving over to Veeam and they have 2 physical SQL servers in a shared active/passive configuration. Right now they use something called Ola hallengren utility to do the backup to a Data Domain device. The DDR is going away, so we need to do something.

Anything coming in the new 9.5 endpoint agents that would be cluster aware? Everything else they have is VMware, this is the only one off.

Thanks
Bill

Mike Resseler
Product Manager
Posts: 5474
Liked: 575 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by Mike Resseler » Nov 03, 2016 7:22 pm

Hi Bill,

No, Veeam Agent for Windows (new name) will not be cluster aware. However, we are going to support a single protection node protection scenario. VAW can be installed on the active node to protect the SQL node. All the goodies such as transaction log backup and truncating will work. Also, item-level recovery will work also.

Hope it helps

Mike

bjdboyer
Enthusiast
Posts: 43
Liked: 2 times
Joined: Nov 16, 2015 5:52 pm
Full Name: Bill Boyer
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by bjdboyer » Nov 03, 2016 8:45 pm

But on cluster fail over the backups fail, right? I would have to make sure to run the backup on the active node of the cluster all the time. Could the Veeam Endpoint Backup service be configured as a cluster resource so it's only active on the node owning the SQL cluster? But thinking on that I don't see how the incrmental changes could be tracked if the node currently running the backup had been passive for a long period of time.

Might just create a CIFS share just for the SQL backups and redirect them there form the data domain. Then Veeam gets the server the CIFS share is on. No real change on the customers part. Just going to a different place. they backup and restore/recovery scripts remain the same. Log processing is already part of that.

Thanks.

Mike Resseler
Product Manager
Posts: 5474
Liked: 575 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by Mike Resseler » Nov 04, 2016 5:53 am

Bill,

You are right... In the scenario that I described you are unprotected at the moment you failover. On the other hand, failing over is hopefully not something you want to stay on for a longer period :-)

Your other solution is also perfect, at least until we will have cluster-aware technology built-in :-)

glamic26
Service Provider
Posts: 21
Liked: 9 times
Joined: Apr 21, 2015 12:10 pm
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by glamic26 » Feb 02, 2017 8:46 am

Mike Resseler wrote:at least until we will have cluster-aware technology built-in :-)
Hi Mike. Is cluster-aware technology on the road map for the Windows Agent? If so any possible timeline? Thanks.

Markus Doll
Novice
Posts: 4
Liked: never
Joined: Jun 30, 2016 8:12 am
Full Name: Markus Doll
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by Markus Doll » Feb 04, 2017 8:59 pm

Is cluster-aware technology on the road map for the Windows Agent? If so any possible timeline?
This is exactly what I'm interested as well.

So far we've 60 sockets licensed and are currently doing the backup of our physical systems with DPM, but as soon as cluster awareness is build in, we'll switch completely to VEEAM.

Best,
Markus

Gostev
SVP, Product Management
Posts: 24020
Liked: 3255 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by Gostev » Feb 05, 2017 6:22 pm

It is planned, but I cannot share any specific timelines just yet.

mianosm
Lurker
Posts: 1
Liked: never
Joined: May 29, 2015 1:46 pm
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by mianosm » May 12, 2017 12:41 pm

Gostev wrote:It is planned, but I cannot share any specific timelines just yet.
It seems like VAW is still not even supported, any insights on the timelines expected for support, and cluster-aware support?

Mike Resseler
Product Manager
Posts: 5474
Liked: 575 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by Mike Resseler » May 15, 2017 2:43 pm

VAW is GA at this moment (If I am not mistaken since last Friday :-))

Cluster-aware support is not in this version but is certainly on our to-do list!

ChuckS42
Expert
Posts: 104
Liked: 13 times
Joined: Apr 24, 2013 8:53 pm
Full Name: Chuck Stevens
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by ChuckS42 » May 24, 2017 9:19 pm

Mike Resseler wrote:VAW is GA at this moment (If I am not mistaken since last Friday :-))

Cluster-aware support is not in this version but is certainly on our to-do list!
Perhaps a premature question, but when cluster support is added, how would this be licensed? One license per cluster node, or one license for the active node?

vClintWyckoff
Expert
Posts: 500
Liked: 109 times
Joined: Oct 27, 2012 1:22 am
Full Name: Clint Wyckoff
Location: Technical Evangelist
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by vClintWyckoff » May 25, 2017 1:35 am

The licensing and edition conversations are not finalized and decided upon.

tknaller
Influencer
Posts: 14
Liked: 1 time
Joined: Jun 01, 2017 9:00 am
Full Name: Thomas Knaller
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by tknaller » Oct 26, 2017 10:38 am

is there any news on backing up mssql cluster with veeam agent for Windows?

jmmarton
Veeam Software
Posts: 1443
Liked: 176 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by jmmarton » Oct 26, 2017 10:49 pm

With VBR 9.5 Update 3's management of agents, that also adds Windows failover cluster support for VAW when VAW is managed by VBR.

Joe

tknaller
Influencer
Posts: 14
Liked: 1 time
Joined: Jun 01, 2017 9:00 am
Full Name: Thomas Knaller
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by tknaller » Oct 27, 2017 6:15 am

awesome thank you, any prospect on its release date?

greetings,
thomas

ChuckS42
Expert
Posts: 104
Liked: 13 times
Joined: Apr 24, 2013 8:53 pm
Full Name: Chuck Stevens
Contact:

Re: Physical SQL Server Cluster Backup Recommendations

Post by ChuckS42 » Oct 30, 2017 4:28 am

vClintWyckoff wrote:The licensing and edition conversations are not finalized and decided upon.
With the release of Windows Cluster support right around the corner, can the question be answered? (one license for the whole cluster, or one license per node)

Post Reply

Who is online

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