I have what I hope is a simple question. What’s the best practice for the a high availabilty SQL server for the VSPC or Veeam ONE configuration database. I see in https://www.veeam.com/kb2301 how to deploy SQL AOAG for VBR and VEM. I’m not sure if this applies to VSPC or Veeam ONE.
Page 1 / 1
Hello
It applies to them too.
Hi
Same steps are applicable! Do not forget to configure the VeeamOne server to use the Availability Group listener as the configuration string for the database. This will ensure it ALWAYS connects to the primary node. Lastly, do not forget to manually test the failover process…
In all honesty, as Veeam ONE is for monitoring only, I wouldn’t HA the database unless you’ve got money to burn.
HA databases can be more trouble than benefit so considering VBR is a single instance, I’d avoid it in general unless service provider or enterprise.
Setting them up is quite straight forward, and well documented here: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-tutorial-single-subnet?view=azuresql
The number 1 thing I see tripping people up with these is that you have to use the full recovery model for database + transaction logs, but then nobody backs up the database and truncates the logs, thereby endlessly growing them. Saw this a few times in VCCs using this because VCC VBRs can’t do any backups themselves. And so they forgot to backup their backup architecture other than config backups and maybe the VBR server itself.
Other than that I’ve seen people targeting the incorrect listener such as the cluster or a server FQDN instead of the always on listener, I also see difference in the authentication configuration between the always on nodes.
Its simple to setup, a headache to fix when it’s wrong because everyone expects it to never have downtime 
♂️
> In all honesty, as Veeam ONE is for monitoring only, I wouldn’t HA the database unless you’ve got money to burn.
Good point! But then he also specified the VSPC. Then I went mute… Here is an interesting link for the later: https://bp.veeam.com/sp/MSP/M_Design/vspc-scale.html
In all honesty, as Veeam ONE is for monitoring only, I wouldn’t HA the database unless you’ve got money to burn.
HA databases can be more trouble than benefit so considering VBR is a single instance, I’d avoid it in general unless service provider or enterprise.
Setting them up is quite straight forward, and well documented here: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-tutorial-single-subnet?view=azuresql
The number 1 thing I see tripping people up with these is that you have to use the full recovery model for database + transaction logs, but then nobody backs up the database and truncates the logs, thereby endlessly growing them. Saw this a few times in VCCs using this because VCC VBRs can’t do any backups themselves. And so they forgot to backup their backup architecture other than config backups and maybe the VBR server itself.
Other than that I’ve seen people targeting the incorrect listener such as the cluster or a server FQDN instead of the always on listener, I also see difference in the authentication configuration between the always on nodes.
Its simple to setup, a headache to fix when it’s wrong because everyone expects it to never have downtime ♂️
Excellent answer
Thanks, everyone. Great answers as always. And as always, the answer for HA or not is “it depends”...but it’s good to see that there are links to relevant KBs for SQL configuration except for VSPC.
The VBR documentation links to this: https://www.veeam.com/kb2301
The VONE documentation links to this: https://www.veeam.com/kb2312
The BP document is really useful for VSPC SQL configuration. Thanks
Thanks, everyone. Great answers as always. And as always, the answer for HA or not is “it depends”...but it’s good to see that there are links to relevant KBs for SQL configuration except for VSPC.
The VBR documentation links to this: https://www.veeam.com/kb2301
The VONE documentation links to this: https://www.veeam.com/kb2312
The BP document is really useful for VSPC SQL configuration. Thanks
You are welcome!
Comment
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.