How to backup an Azure SQL Server database and restore in sql server in a physical server

Question

We have SQL server database in Azure SQL Server instance. I want to backup the database onto a local hard drive and restore it to a physical server. How can I do this?

It seems backup is disabled in Azure SQL Server?

Thanks.

Answer 1

You got a few options to move the data:

• You can use the Azure Database Migration Assistant tool to migrate your data from one database to another.

• You can also export the database in Azure Sql to a .bacpac file, stored in an Azure Storage blob. See this link for more info. You can then download the file and import the .bacpac file in SSMS localy.

  For reference, a .bacpac file is a ZIP file with an extension of 'bacpac' containing the metadata and data from a SQL Server database.