Cloud Backup Robot
Freeware backup software
  • Home
  • SQL Server Backup
  • Download
  • Help
  • Contact
  • Docs.Zone
Select Page ...

8. Creating an Azure SQL Database backup using Cloud Backup Robot

Cloud Backup Robot can create backups of Azure SQL Database. To make it do the job, you have to properly configure the connection between Azure SQL Database and Cloud Backup Robot. Below you can find a detailed description of the process.

8.1 Configure Firewall
  • First, configure your Firewall so that backups could be created from your IP address.
    To do so, visit https://manage.windowsazure.com. Select SQL DATABASES –> SERVERS. You will see the list of the all the servers. Click on the server you need.

Azure - configure your Firewall

  • Press Configure and add your IP to the list of the allowed IP addresses. Your IP address will be detected automatically. Add it by pressing the ( -> ) button.

Add your IP to the list of the allowed IP addresses

  • Your IP will appear in the list of the allowed IP addresses. Press Save.

Your IP will appear in the list of the allowed IP addressesNow you have your Firewall configured and you can create backups from your IP address.

8.2 Obtain Connection String

Then you have to obtain Connection Strings to enable Cloud Backup Robot to connect the SQL server.

  • Select SQL DATABASES –> DATABASES. Then select the required database and click on it.

Obtain connection string

  • Press View SQL Database connection strings.

View SQL Database connection strings

  • Copy the Server and User ID lines as shown on the picture below.

Copy the Server and User ID lines

For example, to connect Cloud Backup Robot to Azure SQL Database, the following parameters can be used (taken from the picture above):

Connect Cloud Backup Robot to Azure SQL Database

Server name: tcp:mkijrfudrpu.database.windows.net, 1433
User name: MyLoginName
Password: Your password (not shown on the picture)

  • Help Topics

    1 About
        1.1 Preparing for use

    2 Getting Started

    3 Backing up
        3.1 Selecting a backup type
        3.2 Entering a job name
        3.3 Selecting data for backup
            3.3.1 Selecting files and folders
            3.3.2 Selecting a SQL Server database
        3.4 Setting backup archive parameters
        3.5 Setting destination storage
            3.5.1 Local folder
            3.5.2 Network folder
            3.5.3 FTP / FTPS / SFTP
            3.5.4 Amazon S3
            3.5.5 Dropbox
            3.5.6 Box
            3.5.7 OneDrive
            3.5.8 Google Drive
        3.6 Scheduling a job

    4 Managing backup jobs
        4.1 Manual backup
        4.2 Pausing/resuming scheduled job
        4.3 Editing job settings
        4.4 Viewing job logs
        4.5 Deleting jobs

    5 Restoring
        5.1 Restoring files and folders
            5.1.1 Selecting backup archive
            5.1.2 Selecting data to restore from archive
            5.1.3 Restoring process and log
        5.2 Restoring databases
            5.2.1 Selecting backup archive
            5.2.2 Selecting restoration method
            5.2.3 Restoring to SQL Server DB
            5.2.4 Selecting databases to be restored
            5.2.5 Restoring to a folder
            5.2.6 Restoring process and log

    6 General settings

    7 Creating a Microsoft SQL Server backup from a remote server
        7.1 Enable remote connections on the instance of SQL Server
        7.2 Enable the TCP/IP connection and configure the TCP port
        7.3 Windows Firewall configuration
        7.4 Remote connection with the SQL Server in the Cloud Backup Robot
        7.5 Creating a new SQL Server user and configuring the Server Roles for the user

    8 Creating an Azure SQL Database backup using Cloud Backup Robot
        8.1 Configure Firewall
        8.2 Obtain Connection String

    • File Backup
    • SQL Server Backup

    Copyright © 2018 Inverse Metric LLC. This website is protected by copyright. Its use outside of the restricted limits of the copyright law is not permitted without the approval of the publisher and is a punishable offense. This particularly applies to the copying, saving and processing in electronic systems. All Rights Reserved.