SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP

Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azure it became trivial. Here’s what you basically need to do:

Once  SQLBackupAndFTP with Azure  is installed, click at “Connect to SQL Server / Azure” button and specify connection properties for your Azure SQL Databases:

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image03

Then click “Run Now” to backup your Azure SQL Database(s):

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image00

Scheduling backups is also very simple – just check “Schedule this job on the main form” to run once daily or go to Advanced Settings for more options

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image04

Sounds simple? There are just a couple more things you need for this to work: you should know your Azure Server Name and Azure should allow your IP to connect. Let me explain how to do it.

How to find your Azure SQL Databases Server Name/Connection String

If you do not know a server name of Azure SQL Database, you can find this out on  Windows Azure Management site.  Sign in with your Microsoft account and click the “SQL DATABASES” menu item, then click your database name

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image01

Then click “Show connection strings” link in the bottom right corner:

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image05

You will see the connection strings for many platforms. Just copy to clipboard “Server” property value of “ADO.NET” connection like in the screenshot below:

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image06

And paste it into the “Server Name” field of the “Connect to SQL Server / Azure” window in SQLBackupAndFTP:

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image07

Allow your IP address to connect  to your Azure SQL Databases server

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 Windows Azure Management site with your Microsoft account, click “SQL DATABASES” menu  item, then click your database:

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image01

Then click “Manage allowed IP addresses” link in the bottom right corner::

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image02

You will see a page where you can specify an allowed IP addresses for your databases:

SQL SERVER - Azure SQL Databases Backup Made Easy with SQLBackupAndFTP image08

On this page you can 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.

Summary

With  SQLBackupAndFTP with Azure it is very simple to take backups of Azure SQL databases as well as of regular SQL Server.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Backup and Restore
Previous Post
SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation
Next Post
SQLAuthority News – Sharding or No Sharding of Database – Working on my Weekend Project

Related Posts

2 Comments. Leave new

  • Hello Dave, do you know if the tool creates a DATABASE COPY before the export?

    Reply
  • Hello Sir, i need to understand Clustering in SQL Server in details  means like what is, how it works, etc… everythings plz help me, if any link u can send me……:)   Abhay Kumar

    Reply

Leave a Reply