Azure SQL Database
Arpio support for Azure SQL Database
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 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.