Backup SQL and VM

Salves 501 Reputation points
2020-06-22T18:07:00.177+00:00

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
Azure Backup
An Azure backup service that provides built-in management at scale.
1,103 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,596 Reputation points
    2020-06-22T18:30:48.477+00:00

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

    Best regards,
    Leon

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Salves 501 Reputation points
    2020-06-22T20:22:33.67+00:00
    0 comments No comments