question

salves avatar image
0 Votes"
salves asked salves edited

Backup SQL and VM

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.

azure-backup
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
1 Vote"
LeonLaude answered

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.

10449-azure-backup-pricing.png

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://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore



Best regards,
Leon




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

salves avatar image
0 Votes"
salves answered salves edited
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.