How to backup and restore Microsoft Azure Cloud SQL Database

Microsoft Azure SQL Database is a managed cloud database from Microsoft. It runs on a cloud computing platform, and access to it is provided as a service. If you use SqlBak for managing your database backups and want to backup Microsoft Azure SQL Database as well, here you will find a step-by-step guide on how to do it.

How to backup Microsoft Azure Cloud SQL Database

1. Connect SqlBak App to the logical SQL Server in the Azure

Go to “Microsoft Azure Dashboard page” and select your SQL Database:Select the “Properties” section to find Server Name and Admin Login: Open SqlBak App, click “Add” and enter the name of the server, choose “SQL Server Authentication” and enter the user name and the password you specified during the Server creation:

2. Create a job for regular Azure SQL Database backup

Go to SqlBak‘s “Dashboard”, click “Add new job” and select “Add backup job”:Add backup job in SqlBak

Select databases to backup Select databases to backup in SqlBak

Then go to the “Store backups in selected destinations” section and press “Add backup destination” to select a place where your Azure SQL Database backups will be stored:Database backup destination placeSuppose, you want to store the backups in Azure Storage. Select “Windows Azure Storage” from the list:Select Windows Azure StorageYou can find your Azure Storage credentials in “Microsoft Azure Dashboard page”:Click “Access keys” and copy the primary access key:Create a new container if necessary:Then go back to SqlBak, enter the primary access key and container’s name and click “Test” to ensure that everything is ok. Then click “Save & Close” button.Windows Azure Storage Settings

Go to the “Schedule backup (full, diff, tran log)” section to set up backup’s schedule:Add SqlBak backup schedule

And finally, click “Save” to save the backup job:Save SqlBak backup job

That’s it. You have successfully set up scheduled Azure SQL Database backups!

How to restore Microsoft Azure Cloud SQL Database

This is even easier! Go to SqlBak‘s Dashboard and click the small restore button  next to the Server name to restore Microsoft Azure SQL Database from the last backup:

In the opened restore dialog click the “Restore” button to start the restore process:

After the restore  process is completed, you’ll receive the following message:

Here you are! Your Azure SQL Database is restored back from Azure Storage.

3 thoughts on “How to backup and restore Microsoft Azure Cloud SQL Database

  1. we use Sql Bak for managing our database backups and the steps mentioned here are useful to backup Microsoft Azure SQL Database .Good post.

  2. Testing now, when restoring to another computer, you cannot pick which SQL Server you want to restore it to? Is that a bug? I have the local SQL server and the Azure server connected on the same machine, but I want to restore the Azure backup to the local machine and it seems to default to the Azure database

    1. Hi Brett,

      With SqlBak you can restore Azure SQL backups only on your Azure SQL instance and there is no way to restore such backups to your Local SQL Server. You can restore your Local SQL Server database backups to another server.

Leave a Reply

Your email address will not be published. Required fields are marked *