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
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
Get started with Enterprise Workloads
Log into the management console to:
Create and manage Administrators and Administrative Groups.
Enable organizations. Alternatively, you may use the Default Organization.
For more information, see Quick reference guide to deploy Enterprise Workloads.
Plan and set up your Azure SQL environment
Plan and set up your Azure SQL environment
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.
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.
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.
Service configuration: The subscription must have Azure Key Vault service (Microsoft.KeyVault) registered under Resource Providers.
Onboard Azure Subscriptions
Onboard Azure Subscriptions
Register your Azure Tenant and authorize Druva to add new subscriptions.
Assign an administrative group to manage subscriptions. If none exist, create one.
Choose Druva storage based on the Azure region where your data resides.
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
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
Configure Azure SQL resources for backup
Configure the backup settings by creating backup policies.
This defines the backup schedule and snapshot retention.Manually configure Azure SQL resources for backup.
Restore Azure SQL resources
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
Review the Troubleshooting Azure onboarding issues.
Related Keywords: Azure SQL QRG