Loading...

Azure SQL Databases

Commvault provides a solution that you can use to perform backup and restore operations on Azure SQL Server databases. Only full backups are supported for Azure SQL instances.

Important: Commvault software supports Microsoft Azure for public clouds only. Sovereign clouds, such as in Germany or China, are not supported. For more information, consult Microsoft documentation. For example, “App Service Regional Details”, https://azure.microsoft.com/en-us/pricing/details/app-service/regional-details/.

Note: When you restore an on-premises database to the Azure cloud, the restored database uses the standard tier model.

Configuration Prerequisites

The solution includes the following components:

  • An Azure SQL instance
  • The ports open to access the Azure cloud. These ports are required to perform management operations on Azure databases.

    Ask your network administrator to open the following ports:

    • Open TCP port 8443 to https://management.core.windows.net:8443.
    • Open TCP port 1433 to *.database.windows.net.

      Note: Depending on your Azure environment, you may require to open additional ports. For more information, see Microsoft documentation, Granting access to Azure SQL Database and SQL Data Warehouse.

If the client accesses Azure through a proxy server, then the user that runs the Commvault services must have the proxy setting configured through Internet Explorer. If the Commvault services run under a Local System account, then perform the following steps to set the proxy settings:

  • Run the command psexec.exe -i -s -d cmd.exe to open a CMD window with the Local System account.
  • Confirm the command by running whoami.exe.
  • Run the iexplore.exe command to set the proxy server.

Best Practice: Verify that the SQL server on the proxy client runs the latest SQL server release to make sure that the proxy server is in sync with the Azure instance. (Azure always has the latest SQL version.) Add the SQL server instance to the CommCell Console or the Command Center.

You do not require Microsoft SQL Server for Azure cloud backups or restores to Azure cloud. You will require Microsoft SQL server installation on the proxy computer only when you are restoring an on-premise backup to the Azure cloud.

Last modified: 7/24/2018 6:28:20 PM