How to backup and restore Microsoft Azure Cloud SQL Database

Microsoft Azure SQL Database is a managed cloud database designed by Microsoft which are widely used by app developers. It works as a service and runs on a cloud computing platform. Here is a step-by-step guide on how to backup Microsoft Azure SQL Database with the help of SQLBackupAndFTP.

How to backup Microsoft Azure Cloud SQL Database

1. Connect SQLBackupAndFTP to the logical SQL Server in the Azure

Go to your “Microsoft Azure Dashboard” page and choose the logical SQL Server in the Azure:

Azure SQL Server SQLBackupAndFTP

You can find your SERVER’s NAME and SERVER ADMIN LOGIN information at the “Properties” section:

Properties Microsoft Azure SQLBackupAndFTP

Run SQLBackupAndFTP and click plus button to create a new backup job. The “Connection to SQL Server” window will be opened automatically where you should specify the name of the server, select “SQL Server Authentication” and enter your User name and Password that you have specified during the Azure logical SQL Server creation:

Connect to Azure logical SQL Server

2. Create a job for regular Azure SQL Database backup

After you have established the connection to your Azure SQLServer select the databases you want to backup. To find the database’s list click on the gear button at the “Selected Databases” section and check off databases you need to backup.

Select databases SQLBackupAndFTP

Then go down to the “Store backups in selected destinations” section and click the plus button to select a place where you prefer to store your Azure SQL Database backups. Assume, you prefer to store the backups in Azure Storage. Choose “Windows Azure Storage” from the list:

Select a place where the backups will be stored

Once you click “Azure Storage” the “Windows Azure Storage Settings” window opens where you need to enter your credentials. You can find your Azure Storage credentials in “Microsoft Azure Dashboard page“.

Microsoft Azure Dashboard SQLBackupAndFTP

Click “Access keys” and copy the primary access key:

Manage keys Microsoft Azure SQLBackupAndFTP

Select or create a new container if necessary:

SQLBackupAndFTP Microsoft Azure select a container

Now open SQLBackupAndFTP, paste the primary access key and specify the container’s name. To check the connection click “Test”, then press “Save & Close” button to apply all settings.

Windows Azure Storage Settings

Turn on “Schedule backups”  to create a backup schedule. Click on the gear button to find additional settings SQLBackupAndFTP Backup Schedule

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

How to restore Microsoft Azure Cloud SQL Database

The restore process is even easier than the backup process! Find the backup you need to restore from the list on the right side of the application. Click on the button next to backup and select “Restore from Backup…”.

SQLBackupAndFTP Restore Microsoft Azure Cloud SQL Database

In the opened window click on “Restore” button

Restore Microsoft Azure Cloud SQL Database with SQLBackupAndFTP

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

Restore Microsoft Azure Cloud SQL Database with SQLBackupAndFTP Success

Here you are! You have just restored Azure SQL Database in a few clicks.

[Total: 3    Average: 3.7/5]

Leave a Reply

Your email address will not be published.