Backup SQL and VM

Question

Hi,

When I set up a SQL backup on a VM I am protecting only the selected database.

If I want to protect the VM should I create a JOB for the virtual machine only?

Does this mean that I will consume the same SQL space twice in Azure Storage?

With this backup of the VM only Azure Backup could very well use SQL Writer VSS to protect both the VM and SQL together.

Or is this SQL backup within the VM an option with greater backup granularity?

Thank you.

Answer 1

Hi,

You can either backup the entire Azure VM, or only the SQL database, or both, the backups can be separate backup jobs.

The pricing is per instance depending on its size + the storage consumed.

When backing-up an SQL Server, the size of the databases configured for backup determine the data size.

Azure Backup pricing
https://azure.microsoft.com/en-us/pricing/details/backup

I'd say backing up only the SQL Server databases is better and easier to maintain.
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore

Best regards,
Leon

Answer 2

dont-backup-your-sql-server-vms-in-azure