Manual Backups

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

Backing up the Azure SQL Database using SSMS

In this section, we will backup the Azure SQL toystore database using SSMS.

  1. Open SQL Server Management Studio and press F8 to open Object Explorer if not already open.
  2. From the Object ...

Get Professional Azure SQL Database Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial