How to take backup from SQL Azure

Hi All,

From last few weeks I’ve been struggling to take backup of a SQL Azure DB.

I believe many of you might have faced this issue.

As per my knowledge & enquiries till date I come to know that, to take a backup from SQL Azure you need to have the Azure management portal access.

But just now I found a great innovative trick to take a backup from SQL Azure.

Here is the simple guide for “How to take backup from SQL Azure”.

Requisites:

·         SQL Server 2012

·         A high speed Internet Connection

Step 1: Open Management Studio & login to your SQL Azure account.

I believe you’d be seeing your Object Explorer like this (Of course with different database list, if you are not in my project :D).

Step 2: Now right click on the DB for which you want to take a backup à Click on ‘Tasks’ à Click on ‘Deploy Database to SQL Azure’.

Step 3: Now you will be seeing a window like following.

   

Click on ‘Next’

Click on ‘Connect’.

A window like following will pop-up.

Login to your local SQL Server instance.

After successfully logging in you’ll be finding a window like following.

  

Click ‘Next’.

Click ‘Finish’.

Now your SQL Azure DB will start deploying to your local SQL Server.

Step 4: After successful deployment to your local SQL Server, you simply can take a backup as you take for normal DBs .

I’ve tested this on my machine & it’s working fine.

Hope it’ll work for you as well.

Any queries feel free to revert back.