SQL 2016 Backup for IaaS VM

Question

SQL 2016 Backup for IaaS VM

Ankit Rathod 411

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 ?

0 comments

Answer accepted by question author

Pranathi Panyam_MSFT 1,071 Microsoft Employee Moderator

@Ankit Rathod

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.

Pranathi Panyam_MSFT 1,071 Reputation points Microsoft Employee Moderator

2021-04-20T14:36:53.227+00:00

@Ankit Rathod 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.

2 additional answers

Your answer

Pranathi Panyam_MSFT 1,071 Reputation points Microsoft Employee Moderator

2021-04-20T14:36:53.227+00:00

@Ankit Rathod 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.

Answer 1

Ankit Rathod 411

@Pranathi Panyam_MSFT , thanks for clarifying we can close this case now.

0 comments

Answer 2

Ankit Rathod 411

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) ?

Pranathi Panyam_MSFT 1,071 Reputation points Microsoft Employee Moderator

2021-04-26T18:00:13.39+00:00

@Ankit Rathod I meant LRS replication.
Pranathi Panyam_MSFT 1,071 Reputation points Microsoft Employee Moderator

2021-05-03T13:47:32.287+00:00

@Ankit Rathod 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.
Ankit Rathod 411 Reputation points

2021-05-03T17:32:29.763+00:00
Hi @Pranathi Panyam_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 ?
Pranathi Panyam_MSFT 1,071 Reputation points Microsoft Employee Moderator

2021-05-04T07:26:11.987+00:00

@Ankit Rathod

Thanks for the quick response, Ankit.
No, not a standard managed disk. It is a standard storage account with LRS replication.

Share via

SQL 2016 Backup for IaaS VM

2 additional answers

Your answer