Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
TomAnthony
Lurker
Posts: 1
Liked: never
Joined: May 26, 2017 11:00 am
Full Name: Tom Anthony
Contact:

Physical SQL Cluster - Advice

Post by TomAnthony » 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?

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 Cluster - Advice

Post by vClintWyckoff » 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.

Post Reply

Who is online

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