Azure SQL Managed Instance - Backup storage redundancy

Question

Hello

I would like to ask how can I change the Backup storage redundancy parameter from Geo-redundant backup storage to Zone-redundant backup storage for Azure SQL managed instance?

When I try to do this I get a message:

Here is the config on the instance:

I found documentation from 2 years ago saying that this parameter cannot be changed, but I would like to make sure if this is still valid. ([https://techcommunity.microsoft.com/t5/azure-sql-blog/configuring-backup-storage-redundancy-in-azure-sql/ba-p/1554322)

Answer 1

@Paweł Przydzial Thanks for reaching out to Microsoft Q&A. I understand that you want to convert your backup storage from GRS to ZRS, is that right?

This should be possible at the moment, please go through this document that provides an overview of how to switch from each type of replication to another- https://learn.microsoft.com/en-us/azure/storage/common/redundancy-migration?tabs=portal#replication-change-table

From GRS to ZRS-

Switch to LRS first, then perform a conversion to ZRS using:

Customer-initiated conversion3,5

• or -

Support-requested conversion3,5

Please note- Customer-initiated conversion is currently in preview and available in all public ZRS regions except for the following:

(Europe) West Europe

(Europe) UK South

(North America) Canada Central

(North America) East US

(North America) East US 2

Hope this helps. If you require any further assistance, please feel free to let us know and we will be glad to assist further. Thank you!

Remember:

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Answer 2

@JimmySalian-2011 @SaiKishor-MSFT Thank you very much for your reply. I confirm that I was able to do the conversion. Interestingly, the conversion succeeded when it was done using the AZ command. Through Azure Portal it was not possible.

Answer 3

Hi,

You can configure backup storage redundancy when you create your instance, and you can update it at a later time at the instance level. The changes that you make to an existing instance apply to future backups only. After you update the backup storage redundancy of an existing instance, it might take up to 24 hours for the changes to be applied. Changes made to backup storage redundancy apply to short-term backups only.

So you should be able to change the backup for SQL MI, [https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql.

If you still have issues can raise a support case with Microsoft.[https://azure.microsoft.com/en-ca/support/create-ticket/

Hope this helps.

JS

==

Please Accept the answer if the information helped you. This will help us and others in the community as well.