The
conventional database backup statement doesn't work in Azure SQL Database. The manual backup consists of exporting the database as a DACPAC (data and schema) or BACPAC (schema) and
bcp
out the data into
csv
files.
The manual backups can be performed in the following ways:
Export BACPAC to Azure Storage Account using The Azure portal
Export BACPAC to Azure Storage Account using PowerShell
Export BACPAC or DACPAC to an on-premises system using
sqlpackage.exe
Export BACPAC using SQL Server Management Studio
In this section, we will backup the Azure SQL
toystore
database using SSMS.
Open SQL Server Management Studio and press F8 to open Object Explorer if not already open.
From the Object Explorer, connect to Azure SQL Server:
Right-click on the
toystore
database, from the right click menu, select tasks, then select Export Data-Tier Application. In the Export Data-tier Application introduction window, click Next to continue...