CODEWITHSUNDEEP
azureazure-sql-databaseazure-storage
Darf Zon
Darf Zon

Reputation: 6378

How to create a backup in Windows Azure

I was trying to create a WindowsAzure backup but I have no success because only create tables structure without data. This is the procedure which I was following:

1.Select the database you want to back up in new portal of windows azure https://manage.windowsazure.com
2.In the footer you will have an option to import/export. Click export. This opens a modal popup. Select the storage account you want to use and type in a appropriate name to save the *.bacpac file.
3.Once the file is saved to storage, download it to local, open sql server 2012 management studio. Select the database server. Right click on it and in the context menu you will find Import Data-Tier Application. Select the bacpac file from you local and follow the settings.

How can I create a backup but also saving the data?

Upvotes: 0

Views: 331

Answers (3)

Richard Mitchell
Richard Mitchell

Reputation: 421

Microsoft recently did a pretty comprehensive blog covering all the ways to backup a SQL Azure database.

http://blogs.msdn.com/b/windows_azure_technical_support_wats_team/archive/2013/03/04/different-ways-to-backup-your-windows-azure-sql-database.aspx

Just so you know - I develop option number 7 :)

Upvotes: 0

Bern
Bern

Reputation: 7951

There are a few approaches apart from the T-SQL scripted approach, two provided by Red Gate are:

  • SQL Azure Backup Application - A free desktop application, as well as a command line tool, that allows you to transfer a complete backup of an SQL Azure database to your local environment, or another environment thta you have access to.
  • SQL Azure Backup Hosted - A hosted solution variant, which has a number of features

Upvotes: 0

Josh E
Josh E

Reputation: 7424

CREATE DATABASE XXXXXX AS COPY OF YYYYY

MSDN link has a full article on all the different ways you can do this, the above is only one of them. LMGTFY: http://msdn.microsoft.com/en-us/library/windowsazure/ff951624.aspx

Upvotes: 3

Related Questions