Locally Redundant Backup Storage option is not available for importing BACPAC Azure SQL Database on both Azure portal or SSMS

Question

It seems "Locally Redundant Backup Storage" option is not available when importing BACPAC Azure SQL Database on both Azure portal or SSMS.

Import BACPAC in SSMS:

Import Database in Azure Portal:

This backup option will remain unchanged even if I try to select and apply the "Locally Redundant Backup Storage" option after the database has been imported on Azure portal.

This backup option is only available to select on New Database in Azure portal:

It is not allow to import BACPAC to overwrite the existing database on Azure.
What is the direct way to import the BACPAC file to create database with Locally Redundant Backup Storage instead of Geo-redundant backup storage?
Thank you.

Answer 1

Hi @KA SAN CHAN ,

Thanks for using Microsoft Q&A !!

Unfortunately, import does not support specifying a backup storage redundancy and the database is created by default with geo-redundant storage redundancy. However, as a workaround you can first create an empty database with the desired storage redundancy using Azure portal or PowerShell and then import BACPAC into this empty database.

Please refer to the limitations section of Import a database from a BACPAC file.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.