Download database data

Question

Hello,

we have already cancelled our account, but we would like to download our data to keep it safe.

We have already downloaded the WordPress data, but we are unable to download the database data; we receive an error message, see also attachment.

How can we download our SQL database data?

This concerns data from TLV-SH.

Username: Azure NonProfit Account ******@tlvsh.onmicrosoft.com

Thank you for your help. Kind regards,

Peter Szigeti

Representative

TLV-SH Germany

Answer 1

To download your SQL database data, you can follow these general steps:

1. Access Azure Portal: Log in to the Azure portal using your Azure NonProfit Account credentials.
2. Navigate to SQL Database: Go to the SQL databases section and select the database you want to export.
3. Export Database: Look for the option to export the database. This is usually found in the settings or overview section of your SQL database.
4. Choose Export Format: You may need to specify the format for the export, such as a BACPAC file, which is commonly used for SQL Server databases.
5. Download the Exported File: Once the export is complete, you should receive a link to download the exported file to your local machine.

If you encounter an error during this process, it may be helpful to check the error message for specific details or consult Azure support for assistance. Additionally, ensure that you have the necessary permissions to perform the export operation.

If you have already cancelled your account, please note that access to certain features may be limited, and it is advisable to reach out to Azure support for further assistance regarding your account status and data access.

---

References:

• Exporting customer data and enabling cloud choice

Answer 2

Hi @webmaster

Thank you for contacting to Microsoft QA.

It sounds like you’re trying to download your SQL database data after canceling your Azure account, and you’ve run into an error during the process. Since you mentioned downloading WordPress data successfully, it's likely that the steps for exporting your Azure SQL Database might need a bit of adjustment.

Here's a general approach for downloading your SQL database data by creating a BACPAC file, which is a package containing the schema and data of the database:

Steps to Export Your Azure SQL Database to a BACPAC File:

1. Log in to the Azure Portal: Go to Azure portal and log in with your credentials.
2. Select Your Database:
   • Navigate to your SQL Server resource where your database is hosted.
     • Click on the database you wish to export.
     1. Initiate the Export Process:
        • On the database overview page, find and select the Export option.
          • You'll need to fill in details like the storage account where you want to save the BACPAC file and the specific container within that storage.
            • Click OK to start the export process.
            1. Track Export Progress:
               • Monitor the export process through the portal. Check for any potential errors or progress updates.
               1. Verify: After the export completes, navigate to your storage account and verify that the BACPAC file is present and intact.

Common Errors and Solutions:

• If the export fails:
  • For databases larger than 200 GB, consider using SQLPackage, which is a command-line utility and can be run in parallel to export subsets of your data for speed.
    • Check that your selected storage account and container have proper permissions enabled for the export operation.
      • Ensure there's enough disk space in the target location for the BACPAC file.

Tips:

• Make sure you're not experiencing any write operations on your database during the export as this can lead to inconsistent data.
• If error messages persist, please provide the specific error message or code so we can troubleshoot further.

Follow-Up Questions:

1. Can you specify the error message you're receiving during the export process?
2. What is the size of your SQL database?
3. Have you checked the permissions for the storage account and container where you're trying to export the data?
4. Could you confirm if there were any recent write activities on the database before you attempted the export?

Hope this helps get you started on downloading your SQL database data securely! If you have any more questions or run into issues, feel free to ask.

References:

• How to Manually Backup an Azure SQL Database
• Using SQLPackage to Import or Export SQL Server and Azure SQL DB