Shared SQL DB

[normunds]

Hello!

We plan to deploy two physical servers (server1 and server2) for Veeam B&R to backup Vmware infrastructure. Install Veeam B&R on both servers and balance new jobs between them. We have powershell script to automatically create new veeam job in case of new VM.
Do we need write some logic to split the VM jobs between these two servers? Or Veeam have some better solution for this situation?
Can I share one SQL database (VeeamBackup DB) located on server1 for veeam installation on server2? Idea to have one veeam DB for all information about server1 and server2 backups!

Thanks!
Normunds

[Vitaliy S.]

Hi Normunds,

Can you please tell me why do you want to create two backup servers? If you want to do job load balancing, then you can use multiple proxy servers. As to sharing database between different Veeam B&R servers, then it is not supported, each server should have its own database.

Thanks!

[normunds]

Hi, Vitaliy!

Thanks for replay!
So, the DB sharing is not good idea!
If I understood correctly I need to install Veeam B&R only to server1. Create secondary backup proxy and backup repository on server2. On Veeam job creation process randomize servers backup proxy's and repository's for resource balancing. Am I correct?
If I select both backup proxy's in job config, how it affects backup process?

Normunds

[Vitaliy S.]

If I understood correctly I need to install Veeam B&R only to server1. Create secondary backup proxy and backup repository on server2. On Veeam job creation process randomize servers backup proxy's and repository's for resource balancing. Am I correct?

Correct, but keep in mind that backup job can only be pointed to a single repository.

If I select both backup proxy's in job config, how it affects backup process?

Selected proxy servers will be used depending on their current workload. Least loaded will pick up new job tasks.

[normunds]

Ok, it's clear now!
Thank you, Vitaliy, for suggestions!

Normunds