Free SQL Server backup software that uploads SQL database backups to FTP, online to Amazon S3, Dropbox and Google Drive cloud. For SQL Server (Express) 2005, 2008 and 2012.

How to backup Azure SQL Database

It is very simple to backup your Azure SQL Databases using SQLBackupAndFTP with Azure

Connect to Azure SQL Database

Run SQLBackupAndFTP with Azure. Click at "Connect to SQL Server / Azure" button on the main window. Specify you Azure SQL Server Name, user name and password for connection.

Connect to Azure SQL

How to find your Azure SQL server name / connection string?

It may not be immediately clear what is your Server Name (connection string) for Azure SQL databases. Here the instructions on how to find it out.

Login to Windows Azure Management. Select "SQL DATABASES" on the left panel, click at any of your databases and click "Show connection string" link.

Azure page

You will see connection strings for a number of platforms. Under ADO.NET select the connection string like in the example to your right. Copy/Paste it to "Server Name" field in SQLBackupAndFTP.

Connection string

How to configure firewall for your database

For SQLBackupAndFTP to connect to Azure SQL Database you need to configure Azure's firewall. Otherwise you will be getting the error: Cannot open [server] requested by the login. Client with IP address [ip-address] is not allowed to access to the server...

Login to your Windows Azure Management, select "SQL DATABASES" item on the left panel, click at any of your databases and find "Manage allowed IP addresses" link on the page. Click it.

Azure Firewall

On this page you need to configure your firewall to allow the machine where SQLBackupAndFTP is running access to Azure. After adding the proper IP you should have no problem connecting to Azure.

Azure Firewall

©Pranas.NET Sql Server Backup MySql Backup MySql Backup to cloud Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups