How to export an Azure SQL Database when subscription is disabled?

Question

Hi everyone,

I have an Azure SQL Database on a subscription that was unexpectedly disabled.

Attempts to export via the Azure portal, sqlpackage, and SSMS all fail with “login failed.” Access from the app is also blocked.

I need to recover the full database (schema + data) for migration purposes.

Any guidance or alternative methods to recover the data would be greatly appreciated.

Thanks!

Answer 1

Hi Active Nights Out,
It sounds like you're in a tricky situation with your Azure SQL Database due to your subscription being disabled. Unfortunately, without a valid subscription, access to the database and export features will be restricted, leading to the "login failed" errors you're experiencing.

Here are some ideas on what you can do to approach this situation:

1. Check Subscription Status: If possible, contact Azure Support to see if there's a way to reactivate or recover your subscription. Getting your subscription back up may allow you to access your SQL Database again.
2. Export via SQLPackage: If your subscription is reactivated and you regain access, you can export your database using the SQLPackage utility. This tool has options for exporting databases and may give you more control than the portal or SSMS. Ensure you run it from a machine with enough local disk space, as exporting can require up to three times the size of your database.
3. Backup in Azure Portal: If you regain access to the portal, follow these steps to export:
   • Log in to the Azure portal.
   • Go to your SQL server and select the database.
   • Click on Export, provide the necessary details, and initiate the process.
4. Service Bus Connections: If you had configured service bus connections, check if any actions can be taken without direct database access to mitigate losses or backups.

Unfortunately, if the subscription remains disabled, your ability to export or recover the data might be limited. In that case, reaching out to Azure support might be necessary to explore any potential recovery options or gaining temporary access.

Follow-Up Questions:

To get a clearer path forward, can you provide more details on the following?

• What caused your subscription to be disabled? Was it related to payment or another issue?
• Have you contacted Azure Support regarding your subscription status?
• Are there specific data or tables that are a priority for you to recover?

References:

• How to Manually Backup an Azure SQL Database
• Using SQLPackage to Import or Export SQL Server and Azure SQL DB
• Export to a BACPAC file - Azure SQL Database and Azure SQL Managed Instance

Hope this helps, and feel free to ask if you have any other questions!

Answer 2

Interesting enough, the most recent question with the Azure SQL Database tag, https://learn.microsoft.com/en-us/answers/questions/5674792/how-to-export-an-azure-sql-database, was from a person in exactly the same situation as you.

As long as your subscription is disabled, you cannot do anything. If you check out the other thread, the person in the other thread opened a support case, and support was kind enough to open the subscription so that he/she could export the database.

How come your subscription is disabled?

Answer 3

If your Azure SQL Database is on a subscription that has been disabled, you will face challenges in exporting the database using the Azure portal, sqlpackage, or SQL Server Management Studio (SSMS) due to access restrictions. Unfortunately, without an active subscription, standard export methods will not work, as they require valid authentication and access to the Azure resources.

Here are a few alternative approaches you might consider:

1. Contact Azure Support: Reach out to Azure Support to see if they can assist in re-enabling your subscription or provide access to your database temporarily for export purposes.
2. Use a Backup: If you have any backups of your database (e.g., from automated backups or manual backups), you can restore from those backups to a new Azure SQL Database once your subscription is active again.
3. Local Copies: If you have previously exported your database schema and data to a BACPAC file or any other format and stored it locally or in a different Azure subscription, you can use that for migration.
4. Recovery Options: If the database is critical, consider discussing recovery options with Azure support, as they may have additional tools or methods to help recover your data.

In summary, without an active subscription, your options are limited, and contacting Azure Support is likely your best course of action.

---

References:

• Export a database using SqlPackage
• Export from the Azure portal
• Automated backups in Azure SQL Database