SQL Backups

[gingerdazza]

Hi. I want to move SQL backups into Veeam and have a few questions....

1. For both single server SQL, and AAG, is it best to use standard VBR backups or agent based backups?
2. If agent based backups, do they require a license (and how much are they?)
3. Can you still run SQL native backups at the same time?

Any other guidance or how best to set it up is welcome.

Thanks

[PetrM]

Hello,

1. I guess by "standard backup" you mean a virtual machine backup? If yes, then I'd suggest using a VM backup because you offload the source server itself: all the compute operations including data block compression, digests, and checksums calculations are performed on a dedicated proxy server and not on the SQL server itself

2. Each workload consumes a license instance, please review our licensing policy and this section of the user guide to get a better idea. Please let us know if you need any clarifications

3. You can run SQL native backups as long as a Veeam job leverages Copy-Only mode

Also, I recommend trying our plug-in for Microsoft SQL Server: it enables SQL native backups directly to Veeam repositories and ensures very high backup performance.

Thanks!