Skip to main content

Protecting Azure SQL: Quick reference guide

Updated this week

Welcome! This guide helps you back up Azure SQL resources such as Azure SQL server on Azure VM, Azure SQL database, and Azure Managed Instance to the secure Cloud.

Understand Azure SQL data protection

Druva helps protect your Azure SQL resources from data loss, ransomware, and other issues. Here's how:

  • Unified management for all Azure SQL resources: SQL on VMs, SQL Databases, and Managed Instances

  • Air-gapped protection against ransomware

  • Unlimited backup retention

  • Flexible backup options, including full and CDC-based recovery points

  • No egress charges for backups to Druva Cloud

Additional resources to help you get started:

Get started with Enterprise Workloads

Log into the management console to:

  1. Create and manage Administrators and Administrative Groups.

  2. Enable organizations. Alternatively, you may use the Default Organization.

Plan and set up your Azure SQL environment

  1. Check compatibility: Make sure your Azure SQL setup is supported. Check the support matrix for details on supported SQL Server versions on Azure VM, features, and supported AWS, Azure, and Gov Cloud regions.

  2. Access and permissions: You must have the Global Administrator role with Microsoft.Authorization/roleAssignments permission. Alternatively, you must have Owner access at the tenant level. To know more, see Roles and permissions for Azure VMs.

  3. Application registration: The Global Administrator role is required to:

    • Register the application in Azure Entra ID.

    • Define and assign custom roles.

    • Provision the Resource Group and Azure Key Vault.

    • Ensure that the Users can register applications setting is enabled in Azure Entra ID.

  4. Service configuration: The subscription must have Azure Key Vault service (Microsoft.KeyVault) registered under Resource Providers.

Onboard Azure Subscriptions

Register your Azure Tenant and authorize Druva to add new subscriptions.

  1. Assign an administrative group to manage subscriptions. If none exist, create one.

  2. Choose Druva storage based on the Azure region where your data resides.

  3. Authorize subscriptions by allowing Druva to create an access key in Azure Key Vault. This key secures your backups.

Once added, Druva automatically detects and lists the VMs under the Azure subscription

Discover SQL Databases

  • Druva automatically finds SQL Managed Instances and SQL Servers.

  • For SQL Servers on Azure VMs, you need to run a one-time manual discovery.

  • Once the SQL servers are discovered, assign valid credentials to be able to discover databases on those servers.

Configure Azure SQL resources for backup

  1. Configure the backup settings by creating backup policies.
    This defines the backup schedule and snapshot retention.

  2. Manually configure Azure SQL resources for backup.

Restore Azure SQL resources

On successful backup, you can restore your SQL resources to the same storage region or across regions. You can restore a database either from a recovery point or to a point-in-time.

πŸ“Œ Additional information

Related Keywords: Azure SQL QRG

Did this answer your question?