--- title: Azure SQL Virtual Machine --- [Skip to content](https://docs.arpio.io/azure/azure-sql-virtual-machine#main-content) English Show submenu for translations [Customer ticket portal](https://docs.arpio.io/tickets-view?hsLang=en) - Home - Products - Pricing - Blog - Company Open main navigation Close main navigation - Home - Products - Pricing - Blog - Company - English Show submenu for translations - [Customer ticket portal](https://docs.arpio.io/tickets-view) Welcome to Arpio Technical Docs - There are no suggestions because the search field is empty. 1. [Arpio Documentation](https://docs.arpio.io/?hsLang=en) 2. [Azure Reference Guides](https://docs.arpio.io/azure-reference-guides?hsLang=en) 3. [Azure Resource Reference](https://docs.arpio.io/azure-reference-guides?hsLang=en#azure-resource-reference) # Azure SQL Virtual Machine Arpio supports recovery of Azure SQL Database workloads. The following resource types are supported: ### **SQL Virtual Machine** Arpio replicates SQL Virtual Machine configurations for SQL Server running on Azure VMs. The data is also replicated when the underlying Virtual Machine disks are replicated. #### Translated Attributes The following attributes are translated during replication: | Attribute | Translation Method | | --- | --- | | Virtual Machine ID | Resource ID of the corresponding recovery VM | | Auto Patching Settings | Applied from tag or default configuration | | Entra Administrator Client ID | Client ID of the corresponding user assigned identity from the recovery VM | | Database principals for Entra identities | Any database principals for user or system assigned identities will be translated to the corresponding recovery environment identities. | The Azure Resource Manager does not return the auto patching settings that were specified when the SQL Virtual Machine was created. When Arpio replicates the VM, it uses these default values: - Day of week: Sunday - Maintenance window duration: 60 minutes - Maintenance window starting hour: 2 AM - Additional VM patch: Based on source `additionalVmPatch` property You can override these defaults by using the `arpio-config:sql-vm-auto-patching-settings` configuration tag containing a JSON dictionary of settings as specified in the [ARM Create API](https://learn.microsoft.com/en-us/rest/api/sqlvm/sql-virtual-machines/create-or-update?view=rest-sqlvm-2023-10-01&tabs=HTTP#autopatchingsettings). #### Automatic Dependency Selection The following resources are automatically selected into recovery points when a SQL Virtual Machine is selected: - The underlying Virtual Machine - The managed identity if used as the Entra administrator - Any managed identities referenced in the database #### Additional considerations if using Entra: - You must grant `Directory.Read.All` and `Organization.Read.All` Entra permissions to the Arpio Primary Delegate. This allows Arpio to look up your Entra IDs to properly mirror them. - You must use a user assigned identity, not a system assigned one for the Entra administrator. System assigned ones are created at failover time and there is no opportunity to assign them the correct Entra permissions. - After initial restore, you must grant the `User.Read.All`, `GroupMember.Read.All`, and `Application.Read.All` Entra permissions to the recovery user managed identity as described [here](https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/configure-azure-ad-authentication-for-sql-vm?view=azuresql&tabs=azure-portal#grant-permissions) prior to conducting a failover or test. This ensures that the recovery SQL server can properly access Entra. - You must grant the Arpio Recovery Delegate the `[sysadmin]` role in the `master` database of your Primary server. Instructions are provided in the issue raised during backup. This ensures that Arpio can update the database principals when the database is cloned to the recovery environment. - The Arpio Delegates use unencrypted connections to communicate with the SQL server. However, all communication happens within virtual networks. - [Getting Started](https://docs.arpio.io/getting-started?hsLang=en#main-content) - [New Account Setup](https://docs.arpio.io/getting-started?hsLang=en#new-account-setup) - [New Application Setup](https://docs.arpio.io/getting-started?hsLang=en#new-application-setup) - [Arpio Fundamentals](https://docs.arpio.io/arpio-fundamentals?hsLang=en#main-content) - [Platform Fundamentals](https://docs.arpio.io/arpio-fundamentals?hsLang=en#platform-fundamentals) - [Platform Features](https://docs.arpio.io/arpio-fundamentals?hsLang=en#platform-features) - [Arpio Reference Guides](https://docs.arpio.io/arpio-reference-guides?hsLang=en#main-content) - [Arpio API](https://docs.arpio.io/arpio-reference-guides?hsLang=en#arpio-api) - [Lifecycle Events](https://docs.arpio.io/arpio-reference-guides?hsLang=en#lifecycle-events) - [Role-Based Access Controls (RBAC)](https://docs.arpio.io/arpio-reference-guides?hsLang=en#role-based-access-controls-rbac) - [Single Sign-On (SSO) Integration](https://docs.arpio.io/arpio-reference-guides?hsLang=en#single-sign-on-sso-integration) - [Test Planning](https://docs.arpio.io/arpio-reference-guides?hsLang=en#test-planning) - [Test & Recovery How-To](https://docs.arpio.io/arpio-reference-guides?hsLang=en#test-recovery-how-to) - [AWS Reference Guides](https://docs.arpio.io/aws-reference-guides?hsLang=en#main-content) - [AWS Resource Reference](https://docs.arpio.io/aws-reference-guides?hsLang=en#aws-resource-reference) - [AWS Configuration Tags](https://docs.arpio.io/aws-reference-guides?hsLang=en#aws-configuration-tags) - [AWS Access](https://docs.arpio.io/aws-reference-guides?hsLang=en#aws-access) - [AWS Testing](https://docs.arpio.io/aws-reference-guides?hsLang=en#aws-testing) - [AWS Solutions](https://docs.arpio.io/aws-reference-guides?hsLang=en#aws-solutions) - [Azure Reference Guides](https://docs.arpio.io/azure-reference-guides?hsLang=en#main-content) - [Azure Resource Reference](https://docs.arpio.io/azure-reference-guides?hsLang=en#azure-resource-reference) - [Azure Configuration Tags](https://docs.arpio.io/azure-reference-guides?hsLang=en#azure-configuration-tags) - [Azure Scenarios](https://docs.arpio.io/azure-reference-guides?hsLang=en#azure-scenarios) - [FAQ](https://docs.arpio.io/faq?hsLang=en#main-content) - [AWS FAQ](https://docs.arpio.io/faq?hsLang=en#aws-faq) - [Contact Support](https://docs.arpio.io/faq?hsLang=en#contact-support) - [License & Billing](https://docs.arpio.io/faq?hsLang=en#license-billing) - [Tests and Recoveries](https://docs.arpio.io/faq?hsLang=en#tests-and-recoveries) - Home - Products - Pricing - Blog - Company [![bubble-wand-tight.64](https://docs.arpio.io/hs-fs/hubfs/bubble-wand-tight.64.png?width=64&height=64&name=bubble-wand-tight.64.png "bubble-wand-tight.64")](https://arpio.io) Copyright © 2026, Arpio