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 see information about your server after clicking on the server’ s name on the Dashboard:
See your server’s name under “Properties”.
Run SQLBackupAndFTP and click plus button to create a new backup job.
Click the gear button next to “SQL Server”, select “SQL Server Authentication” and enter your Server’s name, your User name and Password that you have specified during the Azure logical SQL Server creation:
Push the “Test SQL Connection” button, you have to see a message that the connection test succeeded.
2. Create a job for regular Azure SQL Database backup
After you have established the connection to your Azure SQL Server 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 on 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 have to prepare your Azure Storage Account and see it in “Microsoft Azure Dashboard page“.
If you click on your Storage account name, you will see the picture like this: If you click on your Storage account name (like mybackup2017 for example), you will see a picture like this:
Click “Access keys” and find the primary access key there:
Select or create a new container if necessary:
So, these are the data to fill in to the SQLBackupAndFTP window of Windows Azure Storage Settings.
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.