Physical SQL Server Cluster Backup Recommendations

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

Physical SQL Server Cluster Backup Recommendations

Veeam Logoby bjdboyer » Thu 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
bjdboyer
Influencer
 
Posts: 22
Liked: 1 time
Joined: Mon Nov 16, 2015 5:52 pm
Full Name: Bill Boyer

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby Mike Resseler » Thu 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
Mike Resseler
Veeam Software
 
Posts: 3291
Liked: 366 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby bjdboyer » Thu 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.
bjdboyer
Influencer
 
Posts: 22
Liked: 1 time
Joined: Mon Nov 16, 2015 5:52 pm
Full Name: Bill Boyer

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby Mike Resseler » Fri 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 :-)
Mike Resseler
Veeam Software
 
Posts: 3291
Liked: 366 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby glamic26 » Thu 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.
glamic26
Service Provider
 
Posts: 18
Liked: 9 times
Joined: Tue Apr 21, 2015 12:10 pm

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby Markus Doll » Sat 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
Markus Doll
Novice
 
Posts: 4
Liked: never
Joined: Thu Jun 30, 2016 8:12 am
Full Name: Markus Doll

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby Gostev » Sun Feb 05, 2017 6:22 pm

It is planned, but I cannot share any specific timelines just yet.
Gostev
Veeam Software
 
Posts: 21444
Liked: 2362 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby mianosm » Fri 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?
mianosm
Lurker
 
Posts: 1
Liked: never
Joined: Fri May 29, 2015 1:46 pm

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby Mike Resseler » Mon 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!
Mike Resseler
Veeam Software
 
Posts: 3291
Liked: 366 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby ChuckS42 » Wed 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?
ChuckS42
Enthusiast
 
Posts: 66
Liked: 5 times
Joined: Wed Apr 24, 2013 8:53 pm
Full Name: Chuck Stevens

Re: Physical SQL Server Cluster Backup Recommendations

Veeam Logoby vClintWyckoff » Thu May 25, 2017 1:35 am

The licensing and edition conversations are not finalized and decided upon.
vClintWyckoff
Veeam Software
 
Posts: 410
Liked: 95 times
Joined: Sat Oct 27, 2012 1:22 am
Location: Technical Evangelist
Full Name: Clint Wyckoff


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 22 guests