Physical SQL Cluster - Advice

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

Physical SQL Cluster - Advice

Veeam Logoby TomAnthony » Fri May 26, 2017 11:04 am

Hi, so looking through the forums I can see that VAW does not support Windows Failover Clusters but people have mentioned backup up just the active node.

Do we have any advice or documentation on this?

If I use VAW only to back up the active SQL Cluster node, can it still backup SQL Database etc. if it resides on shared storage?

What happens when restoring? Are there any gotchas because the product is not cluster aware?
TomAnthony
Lurker
 
Posts: 1
Liked: never
Joined: Fri May 26, 2017 11:00 am
Full Name: Tom Anthony

Re: Physical SQL Cluster - Advice

Veeam Logoby vClintWyckoff » Fri May 26, 2017 8:34 pm

This is an unsupported configuration. While yes theoretically you can install the product on each cluster node. But the product is not Cluster Aware we're unable to perform log truncation because access to both nodes is needed. What would happen if the roles were moved to another node in the cluster? Also, restoring to a Cluster will not work either, however just some internal skunk work testing that we've done is you 'can' restore to a standalone SQL server. I should however reiterate this is unsupported.

As we announced at VeeamON last week, VBR v10 and VAW3.0 will add native agent management as well as the support for Windows Failover Clusters ie - SQL AOG.
vClintWyckoff
Veeam Software
 
Posts: 427
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 33 guests