How to backup and restore Azure SQL Database using SQL Server Management Studio

Before upload new server version or new database script the best practice is to do backup. How it works with Azure SQL Database read below.

Note: You must have SQL Server Management Studio to do next steps.

1. Connect to your SQL Server using Management Studio

Connect to SQL Server

2. Click right button on your database and select Tasks -> “Export Data-tier Application …” to create bacpac package with backup of your data.

Export Data-tier Application ...

Go through wizard and get bacpac package which contains schema and data of your DB.

3. Another option to get just schema of your DB is click right button on your database and select Tasks -> “Extract Data-tier Application …”

Extract Data-tier Application ...

 

Go through wizard and get dacpac package which contains just schema of your DB.

 

Now if something goes wrong you can restore your Azure SQL Database clicking right button on Database folder under your server and select “Import Data-tier Application …” to restore bacpac backup.

Import Data-tier Application ...

 

Have a nice deployments!

Leave a Reply

Your email address will not be published. Required fields are marked *