In this blog we will be discussing how to take windows azure sql database backup to cloud storage account on Windows Azure. Let us first login to windows azure portal and create a storage account. Click on Storage, Cloud Services, Quick Create then type the name for the storage and select you region. Finally click on Create cloud service.
Once you finish you should see this screen with the storage account name you gave before.
To give you a background on the backup process the recommended method of backing up Windows Azure SQL Azure database is creating a database copy and then exporting a BACPAC file gives you a transactionally consistent backup file of the database that is portable and can be stored in Windows Azure storage or on-premises locations. This file then can be used for a rollback plan to protect against user or application errors, or in the event of loss of the entire region.
Now let us start the backup process by clicking on SQL Databases, Then click on configure. Click on Automatic for Export Status, select your storage account you created before, enter your backup frequency and retention, enter your credentials then click on save.
If we come back to our portal after the backup took place and check our storage the backup process automatically created a container for us named automated-sql-export.
If we open our container we could see blobs generated by the backup process. In the next blog we will see how we could restore our database from our blobs in the cloud storage.