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 the “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.
If you get the following error message:
Cannot open server <server name> requested by the login. Client with IP address <IP address> is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.
Now the test connection should be successful, set the connection and save the settings.
2. Create a job for regular Azure SQL Database backup
Go to SqlBak “Dashboard”, click “Add new job”, at the popup window select your server and set “Add backup job”.
Select your Azure SQL Server connection at the “Select DBMS connection” section.
Choose databases to backup at the “Select databases” section.
You can find your Azure Storage credentials at the “Microsoft Azure Dashboard” page at your “Storage account” setting.
Go to the “Access key” settings to find your “Account Name” and “Access Key”.
Then go back to SqlBak and enter the Access key and container’s name. Also, you should enter Container Name for your backups. SqlBak will create a container if it does not exist. Click “Test” to ensure that everything is OK, then save the settings by clicking the “Save & Close” button.
To set a backup schedule go to the “Schedule backups” section and set a schedule you need.
All crucial settings are made and you can click “Save & Close” to save the 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 your SqlBak backup job settings and click the small restore button at the “Backup history & restore” section.
In the opened restore dialog check the backup you need to restore and click the “Restore Selected” button.
At the next step, you can choose if a backup should be restored into the same database or into another. Ensure that all the settings are correct and click the “Restore” button.
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.