question

AnkitRathod-6794 avatar image
0 Votes"
AnkitRathod-6794 asked AnkitRathod-6794 answered

SQL 2016 Backup for IaaS VM

I'm planning on hosting a set of servers in Azure. Some of these servers will run SQL Server 2016. These servers will be deployed to different data centers in the same Azure region. These will be part of an Always On availability group

i'll backup the data on the servers using the SQL IaaS Agent Extension

Below are the key requirements for the storage for the different components of the Virtual Machine

Operating System - Speed and availability for the storage priority
Database and logs - Speed and availability for the storage priority
Backups - This should use the lowest cost option for storage

which of the following is the ideal backup storage solution and why

  • Geo redundant storage account

  • Premium managed disk

  • Standard managed disk

  • Read Access Geo redundant storage account

And Please also explain why ?






azure-sql-virtual-machinesazure-virtual-machines-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.

PranathiPanyam-MSFT avatar image
0 Votes"
PranathiPanyam-MSFT answered PranathiPanyam-MSFT commented

@AnkitRathod-6794

Welcome to Microsoft Platform. Thankyou for posting your Query here.

If you are looking for low cost solutions, standard_LRS would be the suitable option. However, redundancy options in LRS are less compared to other replication type. For better redundancy - you can prefer GRS/RA-GRS.

Please refer : Azure Storage redundancy

Please, go-through the storage pricing calculator for better understanding on pricing details.

Please refer the link for more details on Azure Storage for SQL Server backup and restore


Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.



Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

· 1
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.

@AnkitRathod-6794 Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further queries do let us know.

0 Votes 0 ·
AnkitRathod-6794 avatar image
0 Votes"
AnkitRathod-6794 answered PranathiPanyam-MSFT commented

Just wanted to confirm from above Option what is the suitable Answer ?

For Cost effective solution, when you say Standard_LRS do you mean Standard Managed disk(from the above mentioned option's) ?

· 4
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.

@AnkitRathod-6794 Just Curious to check if there is anything else that I can answer. If this answers your query, do click Up-Vote for the same. And, if you have any further queries do let us know.

0 Votes 0 ·

Hi @PranathiPanyam-MSFT ,

Apologies delay in response and for keeping this case open.,

you mean from the below mentioned option, Suitable answer will be

  • Geo redundant storage account

  • Premium managed disk

  • Standard managed disk

  • Read Access Geo redundant storage account


LRS replication type but for the Standard Managed Disk Correct ?



0 Votes 0 ·
Show more comments
AnkitRathod-6794 avatar image
0 Votes"
AnkitRathod-6794 answered

@PranathiPanyam-MSFT, thanks for clarifying we can close this case now.

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.