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:
You can find your SERVER’s NAME and SERVER ADMIN LOGIN information at the “Properties” section:
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:
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.
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:
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“.
Click “Access keys” and copy the primary access key:
Select or create a new container if necessary:
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.
Turn on “Schedule backups” to create a backup schedule. Click on the gear button to find additional settings
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…”.
In the opened window click on “Restore” button
After the restore process is completed, you’ll receive the following message:
Here you are! You have just restored Azure SQL Database in a few clicks.