Search This Blog

Monday, December 9, 2019

How to Backup Azure SQL Database to Local - Part 1

In this post, we are looking into a way to backup Azure SQL Database which resides on PaaS to local or back to customer on-prem.

This is Part 1 of the tools.

[Pre-requisite preparation]

  • Create any Windows VM operating system. We used Win 10.
  • Install SQL Server Management Studio (SSMS). It require the latest DAC library installed.To download, click here
  • Add Service endpoint on virtual network. Go to Virtual Network > Add Service Endpoint > Microsoft.SQL

  • On SQL Database, open Azure SQL Database Firewall to allow access to the VM

Tool 1: Export a Data Tier Application Using SSMS

  • Open SSMS Tools and Connect to your Azure SQL Database
  • Right click select your database > Tasks > Export Data Tier Application

It will create BACPAC file which will create an exact copy of the database.

This process is manual procedure.

Review Part 2 here.