Click here to Skip to main content
14,774,529 members
Articles » Cloud Computing » Azure » General
Tip/Trick
Posted 1 Oct 2013

Stats

8.6K views
1 bookmarked

How to Take Backup from SQL Azure using Database Deployment Technique

Rate me:
Please Sign up or sign in to vote.
4.50/5 (2 votes)
1 Oct 2013CPOL
Taking a SQL Azure database backup to Local instance from an SQL Azure instance using Deployment Technique

Introduction

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.

Background

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.

Image 1

Step - II

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

Image 2

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

Image 3

Step - III

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

Image 4

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

Image 5

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

Image 6

Now click on "Next" & proceed.

Image 7

Step - IV

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

Image 8

Deployment will be started. Wait till it completes.

Image 9

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.

History

  • 1st October, 2013: Initial post

License

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

Share

About the Author

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

Comments and Discussions

 
-- There are no messages in this forum --