Page 1 of 1

Physical SQL Cluster - Advice

Posted: May 26, 2017 11:04 am
by TomAnthony
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?

Re: Physical SQL Cluster - Advice

Posted: May 26, 2017 8:34 pm
by vClintWyckoff
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.