Azure SQL Deleted Database cannot restore because of region restriction

1
votes

Is there any way to change the region for a Azure SQL server/database from one geographical region to another region?

I have a deleted database which I cannot restore as I get "MSDN subscriptions are restricted from provisioning in this region. Please choose a different region. For exceptions to this rule please contact Microsoft Support."

The Server was originally setup in US-West region with a VS MSDN Subscription.

1
azureazure-sql-database

1 Answers

2
votes

To answer the ways to change region from Azure SQL database, there are mutiple options -

  1. Configure active geo-replication for Azure SQL Database in the Azure portal and initiate failover

  2. Copy an Azure SQL database

  3. Export an Azure SQL database to a BACPAC file

  4. Set up SQL Data Sync (Preview)

However, based on the error if there is limitation on specific region and you have strict requirement to have database in same region you may need to work with Azure support on it.