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 backupSelect 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.

[Total: 4    Average: 4.3/5]

Post navigation


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s