---
title: Azure SQL Database
---

[Skip to content](https://docs.arpio.io/azure/azure-sql-database#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 Database

Arpio supports recovery of Azure SQL Database workloads. The following resource types are supported:

### **SQL Database**

Arpio replicates SQL Databases into the recovery environment. During initial backup, Arpio creates a replica of the database in the recovery region and subscription, but inside of the ArpioRecoveryData resource group. Azure SQL keeps this replica up to date with data changes from the primary in near-real time. This replica is only used for data transfer and is not accessible by your application.

At recovery time, Arpio creates a writeable copy of this replica in your application's recovery resource group.

#### Translated Attributes

The following attributes are translated during replication:

| Attribute | Translation Method |
| --- | --- |
| Database principals for Entra identities | Any database principals for user or system assigned identities will be translated to the corresponding recovery environment identities. |

#### Automatic Dependency Selection

The following resources are automatically selected into recovery points when a SQL Database is selected:

- Azure SQL Server (logical server) containing the database
- Managed Identities referenced inside of the database (if Arpio is granted read access to your database)

#### Limitations

- Data is not point-in-time consistent with the backup. Instead, it is consistent with the point-in-time the recovery was initiated.
- Dependencies to managed identities will not be discovered until read permissions are given to the Arpio Primary Delegate.
- Transparent data encryption is not currently supported.
- Linked servers, transactional replication, and SQL Data Sync are not supported.

### **Azure SQL Server**

Arpio replicates SQL Servers (logical servers) into the recovery environment. During initial backup, Arpio creates a SQL Server in the recovery subscription and region but inside of the ArpioRecoveryData resource group. This server houses the database replica and is not accessible to your application.

At recovery time, Arpio creates a replica of the primary SQL Server in the recovery resource group.

#### Translated Attributes

The following attributes are translated during replication:

| Attribute | Translation Method |
| --- | --- |
| Name | Generates a unique name derived from the original |
| Administrator Password | Retrieved from the Key Vault URL specified in the [`arpio-config:admin-password-secret`](https://docs.arpio.io/azure/arpio-configadmin-password-secret?hsLang=en) tag |
| Entra Administrator | Translated to corresponding recovery-side mirror |

#### Automatic Dependency Selection

The following resources are automatically selected into recovery points when a SQL Server is selected:

- SQL Databases contained within the server
- Firewall rules
- Outbound firewall rules
- Connection policies
- DNS aliases
- Virtual network rules

### **SQL Server Firewall Rule**

Arpio replicates Azure SQL Server Firewall rules to the recovery environment.

### **SQL Server Outbound Firewall Rule**

Arpio replicates Azure SQL Server Outbound Firewall rules to the recovery environment.

### **SQL Server Connection Policy**

Arpio replicates the Azure SQL Server Connection Policy for each Azure SQL Server to the recovery environment.

### **SQL Server DNS Alias**

Arpio replicates the Azure SQL Server DNS Alias resources to the recovery environment.

The following attribute is translated during replication:

| Attribute | Translation Method |
| --- | --- |
| Name | Updated to match the name of the recovery SQL Server |

### **SQL Server Virtual Network Rule**

Arpio replicates the Azure SQL Server DNS Alias resources to the recovery environment.

- [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