Click here to Skip to main content
13,052,641 members (62,440 online)
Click here to Skip to main content
Add your own
alternative version


1 bookmarked
Posted 1 Oct 2013

How to Take Backup from SQL Azure using Database Deployment Technique

, 1 Oct 2013
Rate this:
Please Sign up or sign in to vote.
Taking a SQL Azure database backup to Local instance from an SQL Azure instance using Deployment Technique


In this tip, I'm trying to explain how to achieve the objective of taking a backup of a database which is available/hosted in SQL Azure instance.


I'm sure a good number of people must have faced the issue of taking a backup from SQL Azure. Since SQL Azure behaves differently unlike a local SQL Server instance, you won't find the "Back Up" & "Restore" options under "Tasks" while connected to a SQL Azure instance.

But sometimes we need an Azure database in our local machine for some analysis or as a backup. To achieve this objective, I prepared this tip using a feature provided by SQL Azure.

Using the Code

The following are the images with description which show how to proceed step by step to take a back up from SQL Azure.

Step - I

Connect to the SQL Azure instance.

Step - II

Now you'll be seeing the complete list of databases available in your subscription as follows:

Now you select the database, of which you want to take a back up --> Right Click --> Tasks --> Deploy Database to SQL Azure.

Step - III

The following screen will pop up. Click on "Next".

The following screen will pop up. Click on "Connect".

The following screen will pop up. Provide authentication details & connect.

Now click on "Next" & proceed.

Step - IV

Now you'll be seeing a screen like the following which will show all details of your deployment. Simply click on "Finish'.

Deployment will be started. Wait till it completes.

Step - V

Once deployment is successful, the database will be available to you as a local database. Now you can easily take a back up of it using any technique you know.

Points of Interest

  • This is basically a tweaked way of taking a back up from SQL Azure.
  • The deployment may take minutes to hours depending upon your source database size & internet connection.


  • 1st October, 2013: Initial post


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer (Senior) Autodesk
Singapore Singapore
A person who is in search of opportunities to show his capabilities & knowledge.

You may also be interested in...


Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170713.1 | Last Updated 1 Oct 2013
Article Copyright 2013 by P_Dash
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid