fem wrote:
Hi all,
I have a request to back up several Microsoft Azure Virtual Machines hosting SQL Server and Oracle databases using Veeam Backup for Microsoft Azure (VBAz).
I’m looking for a clear summary of what can and can’t be done when using VBAz for these workloads, ideally in a concise, bullet-point format.
Specifically:
Can application-aware processing fully protect SQL and Oracle databases?
Is transaction log backup and point-in-time restore supported for SQL?
Can individual databases be restored without restoring the entire VM?
Are there scenarios where Veeam Agent for Windows or Linux is required instead?
Any guidance, best practices, or references would be greatly appreciated.
Thanks in advance!
Hi @fem
You can restorehttps://helpcenter.veeam.com/docs/vbazure/guide/performing_restore.html?ver=8
VM
SQL
CosmosDB
File share
Virtual network configuration
Performing Instant recovery
Exporting Disk
Restoring to AWS
Restoring to Google Cloud
Restoring to Nutanix AHV
-Can application-aware processing fully protect SQL and Oracle databases?
AAP in VMBA is not available in the same way it is with traditional on-prem VBR
Azure VM use native Azure snapshot and store them in Blob Storage
Support FLR and entire Vm restore (Vm image backup and Crash-consistend backup
Alternatively, you can use SQL Server Maintenance Plans or Oracle RMAN to perform full and transaction log backups on a local disk of the VM or azure share. Then schedule a VM backup job to save the disk backups.
-Is transaction log backup and point-in-time restore supported for SQL?
No
AAP for SQL & Oracle maybe you can need use Veeam Agent for Windows/Linux inside the VM in standalone mode (Never tried on a server in Azure)
If, on the other hand, you already have an existing VBR on-prem infrastructure, you can use Object storage or backup repos. repository.https://helpcenter.veeam.com/docs/agentforwindows/userguide/operation_modes.html?ver=60
support Storage Type in standalone mode
Local Disk (USB/internal) Recommended for portability
SMB Network Share Use UNC path
Veeam Repository(manual) Requires credentials
OneDrive (new in v6) For personal data, not full system
support Storage Type in managed mode
Local storage
Object Storage
Shared Folders
VBR Repositiry
Veeam Cloud connect
-Can individual databases be restored without restoring the entire VM?
if use Veeam agnet yes
Are there scenarios where Veeam Agent for Windows or Linux is required instead?
i use it for backup MS cluster whit shared physical disk Quorum, Vmware snapshot dont work on shared physical disk
regards