Microsoft Azure performs automatic database backups, where you can restore your database. However, there are scenarios, such as the migration to App Services, where you might need a manual backup by exporting your database. In that case, you can’t simply restore your data using the “Restore” button.ere are the instructions step by step on how to do it.

Today, I will give you the step-by-step instructions to do so.

Delete your problematic data

In order to import your database from a BACPAC file with the same name, you have to delete the current problematic database first.

Login to Azure Portal, go to the “SQL Servers” tab and select your server.

Azure Server ScreenSelect your database.

Azure Database ScreenClick the “Delete” button and select “Yes”.

Azure Delete Database

The deletion will be completed with the following notification:

Delete Notification

Import your data

Go to the “SQL Servers” tab, select your server and click the “Import Database” button.

Azure Import Database

At the “Import Database” blade, configure your subscription.

Configure Subscription

At the “Import Database” blade, configure your storage.

Configure Storage

Select the container that has your backup file.

Select Container

Select the backup file and click the “Select” button.

Select Bacpac

Type your database name, the server admin login and password and click the “OK” button.

Database Login

The following notification informs you of the import’s progress.

Import Progress

When the import process is finished, you will check your restored database at the server databases.

Restored Database

Summary

In order to import your database backup to your existing database you have to follow the steps below:

  • Delete your existing database.
  • Import your database backup to a new database with the same name as the one deleted.

Enjoy your cloud adventures!

Georgia Makoudi

Author Georgia Makoudi

Georgia is a Cloud Specialist at LightBuzz. During the past ten years, she’s been developing secure server-side infrastructures for financial institutions and the healthcare industry. She’s blogging about Windows Azure. Did we mention that she loves Escape Rooms?

More posts by Georgia Makoudi

Join the discussion One Comment

Leave a Reply