question

microccc avatar image
0 Votes"
microccc asked microccc edited

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

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:
140139-import-bacpac-in-ssms.png

Import Database in Azure Portal:
140241-import-database.png

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:
140223-create-sql-database.png


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.








azure-sql-database
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.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered microccc edited

Hi @microccc,

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.

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

Thank you for your information.
Hope to see if there is a feature to select the backup storage redundancy, import or restore to the same database in the future, thanks.

1 Vote 1 ·