Enterprise reference design

A resilient enterprise web application with private regional origins

A two-region App Service design using Front Door Premium Private Link, SQL failover groups, managed identities and tested recovery boundaries.

Cloud architectsApplication platform engineersDatabase and recovery owners

The enterprise use case

Design for the actual operating context.

An enterprise order-management portal serves authenticated employees and partners over the internet. Its application and database origins must reject direct public access, while a regional failure must have a rehearsed recovery path that preserves clear data-loss decisions.

Required outcomes

  • Expose one authenticated public edge while keeping origins private
  • Separate application failover from database failover decisions
  • Test private DNS and identity paths in both regions
  • Separate regional availability recovery from clean cyber recovery

Enterprise architecture

Explore the design, one view at a time.

Public edge and private regional origins

Front Door Premium serves public HTTPS while its managed Private Link connections protect application origins.

Resilient web with private origins — Public edge and private regional originsFront Door Premium serves public HTTPS while its managed Private Link connections protect application origins.. Official Microsoft service icons; explicit resource and network boundaries. Green numbered steps match the F-numbered flow register below the diagram. Resilient web with private origins Public edge and private regional origins Front Door Premium serves public HTTPS while its managed Private Link connections protect application origins. Client access Public DNS and TLS Global edge Front Door Premium Managed connection A Front Door service boundary Application region A Managed PaaS outside the VNet VNet A Outbound integration only Managed connection B Front Door service boundary Application region B Equivalent regional deployment VNet B Outbound integration only F1: Public HTTPS. The public portal domain resolves to Front Door. The associated WAF policy evaluates ingress. Authenticated responses are excluded from public caching. F3: Healthy origin. Front Door selects the primary or secondary origin by priority and health; each has an approved regional managed Private Link connection. F4: Private origin A. The managed West Europe Private Link endpoint reaches the primary production App Service over HTTPS, using verified hostname and certificate settings. F5: Private origin B. The independent managed North Europe endpoint reaches the secondary production app. These endpoints are not inside workload VNets and do not support App Service slots as origins. F6: Outbound integration. App Service VNet integration provides outbound connectivity to private dependencies; it does not implement inbound Private Link. F7: Outbound integration. The secondary production app has separately tested outbound integration before failover. Employees / partners Employees / partners Front Door Premium Front Door Premium Associated WAF policy Associated WAF policy Managed Private Link A Managed Private Link A App Service A. Premium v3 App Service A Premium v3 Integration subnet A Integration subnet A Managed Private Link B Managed Private Link B App Service B. Premium v3 App Service B Premium v3 Integration subnet B Integration subnet B Public HTTPS 1 Healthy origin 3 Private origin A 4 Private origin B 5 Outbound integration 6 Outbound integration 7 Private origins do not make public ingress private Users reach the public Front Door endpoint and its WAF. Disable App Service public origin access and approve the correct managed Private Link connections. Both origins belong to the origin group Step 3 illustrates selection of region A; region B has its own approved private origin path in step 5. Health probes and origin policy determine traffic selection. Reference design · Microsoft product icons used under Microsoft’s published terms · Numbered steps refer to the accompanying flow register
9 components · 6 numbered connections

Green step numbers match the F-numbered flow register below. Solid boundaries show ownership; dashed blue boundaries show networks. Logical groups are labeled explicitly. Microsoft service icons identify the components.

Identity and private SQL dependencies

Tenant authentication is separate from regional outbound networking, private endpoints and SQL listener resolution.

Resilient web with private origins — Identity and private SQL dependenciesTenant authentication is separate from regional outbound networking, private endpoints and SQL listener resolution.. Official Microsoft service icons; explicit resource and network boundaries. Green numbered steps match the F-numbered flow register below the diagram. Resilient web with private origins Identity and private SQL dependencies Tenant authentication is separate from regional outbound networking, private endpoints and SQL listener resolution. Clients User authentication Tenant authority Outside application VNets Logical database endpoint Failover-group listener name Region A resources Managed SQL is outside the VNet VNet A Private DNS, endpoints and integration Region B resources Managed SQL is outside the VNet VNet B Validated cross-region peering F2: Authenticate. Entra authentication and application authorization are separate from private origin networking; WAF does not grant access to business data. F8: Local path. The app reaches its approved SQL or vault private endpoint. SQL and Key Vault have distinct endpoint objects and permissions. F9: Cross-region peering. Global VNet peering and tested network rules allow the secondary app to reach the still-primary SQL endpoint. Validate the reverse direction and each local path too. F10: Private SQL A. The selected SQL private endpoint reaches logical server A. Vault access follows its separate endpoint to the regional vault. F11: Private SQL B. The secondary SQL private endpoint reaches logical server B after role changes. Runtime identities and vault access are configured independently. F13: Listener DNS. Both VNets link to the shared SQL private DNS zone. The logical read/write listener resolves the current primary through its private endpoint; it is not a network appliance. Employees / partners Employees / partners Microsoft Entra ID Microsoft Entra ID SQL failover listener SQL failover listener Azure SQL A Azure SQL A Azure SQL B Azure SQL B Integration subnet A Integration subnet A Private endpoints A Private endpoints A Private DNS links A Private DNS links A Integration subnet B Integration subnet B Private endpoints B Private endpoints B Authenticate 2 Local path 8 Cross-region peering 9 Private SQL A 10 Private SQL B 11 Listener DNS 13 A regional endpoint is not a regional SQL failover Region B can reach the current primary through verified peering to region A. Region B endpoints provide the private path when its SQL server becomes primary. Prove name resolution from both runtimes Private DNS zone links are configuration, not application traffic. Test the listener, CNAME chain and private destination before and after failover; use Entra-based database authorization. Reference design · Microsoft product icons used under Microsoft’s published terms · Numbered steps refer to the accompanying flow register
10 components · 6 numbered connections

Green step numbers match the F-numbered flow register below. Solid boundaries show ownership; dashed blue boundaries show networks. Logical groups are labeled explicitly. Microsoft service icons identify the components.

Release, replication and clean recovery

Equivalent deployments and monitored replication support outage recovery; trusted restoration is a distinct procedure.

Resilient web with private origins — Release, replication and clean recoveryEquivalent deployments and monitored replication support outage recovery; trusted restoration is a distinct procedure.. Official Microsoft service icons; explicit resource and network boundaries. Green numbered steps match the F-numbered flow register below the diagram. Resilient web with private origins Release, replication and clean recovery Equivalent deployments and monitored replication support outage recovery; trusted restoration is a distinct procedure. Release authority Reviewed change Application region B Equivalent release Application region A Application runtime Operations Monitor and App Insights SQL region A Current primary SQL region B Geo-secondary Recovery points Configured SQL backups Clean recovery Trusted environment F14: Equivalent releases. Reviewed releases deploy the same immutable application artifact and compatible configuration to both regional apps. Deployment authority is separate from runtime authority. F15: App telemetry. Both regions emit redacted request, exception and dependency telemetry; platform metrics and resource logs provide additional coverage. F12: Async replication. The Azure SQL failover group replicates selected user databases asynchronously. This managed service path does not replicate surrounding server, app, identity or network configuration. F16: Restore / validate. Choose an existing clean recovery point and a supported restore method/location. Rebuild and verify trusted configuration; the live replica is not assumed clean. Reviewed pipeline Reviewed pipeline App Service B App Service B App Service A App Service A Application Insights Application Insights Azure SQL A Azure SQL A Azure SQL B Azure SQL B SQL recovery points SQL recovery points Restore and validate Restore and validate Equivalent releases 14 App telemetry 15 Async replication 12 Restore / validate 16 Recovery objectives must be measured SQL replication is asynchronous and applies to supported user databases. Failover does not replicate every server setting, identity, secret or application dependency. Separate outage and cyber recovery Regional failover may preserve a compromised state. Restore known-good recovery points into a trusted deployment, validate data and credentials, then authorize return to service. Reference design · Microsoft product icons used under Microsoft’s published terms · Numbered steps refer to the accompanying flow register
8 components · 4 numbered connections

Green step numbers match the F-numbered flow register below. Solid boundaries show ownership; dashed blue boundaries show networks. Logical groups are labeled explicitly. Microsoft service icons identify the components.

Follow the numbered connections

Flow register

Paths shown in the diagram have the following scope.

FlowFrom → toPurpose and control
F1TrafficEmployees and partners Azure Front Door PremiumPublic HTTPS

The public portal domain resolves to Front Door. The associated WAF policy evaluates ingress. Authenticated responses are excluded from public caching.

F2Identity & controlEmployees and partners Microsoft Entra IDAuthenticate

Entra authentication and application authorization are separate from private origin networking; WAF does not grant access to business data.

F3TrafficAzure Front Door Premium Managed Private Link AChoose healthy origin

Front Door selects the primary or secondary origin by priority and health; each has an approved regional managed Private Link connection.

F4TrafficManaged Private Link A App Service Premium v3 APrivate origin A

The managed West Europe Private Link endpoint reaches the primary production App Service over HTTPS, using verified hostname and certificate settings.

F5TrafficManaged Private Link B App Service Premium v3 BPrivate origin B

The independent managed North Europe endpoint reaches the secondary production app. These endpoints are not inside workload VNets and do not support App Service slots as origins.

F6TrafficApp Service Premium v3 A VNet integration subnet AOutbound integration A

App Service VNet integration provides outbound connectivity to private dependencies; it does not implement inbound Private Link.

F7TrafficApp Service Premium v3 B VNet integration subnet BOutbound integration B

The secondary production app has separately tested outbound integration before failover.

F8TrafficVNet integration subnet A Private endpoints ALocal dependency path

The app reaches its approved SQL or vault private endpoint. SQL and Key Vault have distinct endpoint objects and permissions.

F9TrafficVNet integration subnet B Private endpoints APeered cross-region path

Global VNet peering and tested network rules allow the secondary app to reach the still-primary SQL endpoint. Validate the reverse direction and each local path too.

F10TrafficPrivate endpoints A SQL logical server APrivate SQL access A

The selected SQL private endpoint reaches logical server A. Vault access follows its separate endpoint to the regional vault.

F11TrafficPrivate endpoints B SQL logical server BPrivate SQL access B

The secondary SQL private endpoint reaches logical server B after role changes. Runtime identities and vault access are configured independently.

F12RecoverySQL logical server A SQL logical server BAsync user DB replication

The Azure SQL failover group replicates selected user databases asynchronously. This managed service path does not replicate surrounding server, app, identity or network configuration.

F13TrafficPrivate DNS links A SQL failover-group listenerListener name resolution

Both VNets link to the shared SQL private DNS zone. The logical read/write listener resolves the current primary through its private endpoint; it is not a network appliance.

F14RecoveryReviewed deployment App Service Premium v3 BDeploy equivalent releases

Reviewed releases deploy the same immutable application artifact and compatible configuration to both regional apps. Deployment authority is separate from runtime authority.

F15MonitoringApp Service Premium v3 A Monitor and App InsightsApplication telemetry

Both regions emit redacted request, exception and dependency telemetry; platform metrics and resource logs provide additional coverage.

F16RecoverySQL backup recovery points Trusted recovery deploymentRestore then validate

Choose an existing clean recovery point and a supported restore method/location. Rebuild and verify trusted configuration; the live replica is not assumed clean.

Assumptions to confirm

  • West Europe and North Europe are the example paired regions, subject to capacity and residency approval
  • The portal is stateless between requests and uses Azure SQL Database for durable order state
  • Both regional deployments are provisioned before an incident
  • A proposed 30-minute regional recovery target and five-minute data-loss tolerance require business approval and testing
  • This is a documentation-reviewed reference design, not a tested recovery guarantee

Use case and recovery contract

This enterprise order portal serves authenticated employees and partners through public HTTPS. Regional application origins, SQL servers and vaults reject direct public data-plane access. Private origins do not make client ingress private: Front Door remains internet-facing.

Use West Europe as the initial application and database primary, and North Europe as the warm secondary. Propose a 30-minute regional recovery objective and a maximum five-minute business tolerance for lost orders as workshop inputs, not service guarantees. If the business cannot lose acknowledged orders, asynchronous database replication alone is insufficient; revise the transaction and recovery design before approval.

Regional outage recovery moves service to healthy infrastructure. Cyber recovery establishes a trusted application, identity configuration and clean dataset. Replication can copy malicious writes and deletions, so these are separate runbooks.

Component and control matrix

Component Selected baseline Decision and owner
Global ingress Front Door Premium with WAF policy Edge team owns domains, TLS, rule tuning and origin approval
Regional web tier App Service Premium v3, initially P1v3 and at least two instances per region Application team load-tests capacity; enable zone redundancy where the region and scale unit support it
Origin connectivity Front Door managed Private Link endpoint per region Network team approves only expected connections and disables public origin access
Outbound application network Regional VNet integration in a delegated subnet Network team maintains separate integration and private-endpoint subnets
Database Azure SQL Database General Purpose, provisioned compute, matching regional capacity and a failover group Database owner selects compute from tests and approves every forced failover
Secrets and identities Regional managed identities and regional Key Vaults Identity owner limits permissions; application team manages equivalent configuration
Name resolution Shared SQL Private DNS zone linked to both VNets; regional vault records Network team tests both directions and failover listener resolution
Observability and backups Application Insights, platform metrics, selected resource logs and documented SQL backup retention Operations owns alert delivery; recovery owner proves restore usability

Premium v3 enables the selected App Service capabilities, but availability-zone support also depends on the actual scale unit. Provision sufficient warm capacity: autoscaling during an outage is not reserved capacity. App Service reliability constraints.

Trust and network boundaries

Front Door Premium creates its origin private endpoints in Microsoft-managed regional networks, outside the application’s VNets. Approve each connection on its intended App Service resource, configure the correct origin hostname and certificate validation, then verify public access is disabled. Use different supported Private Link regions for the two origins. App Service deployment slots are not supported as Front Door Private Link origins; this design routes to two production apps, not slots. Front Door Private Link support and web-app setup.

App Service remains a managed PaaS service outside the VNet. Its private endpoint is inbound connectivity; VNet integration is outbound connectivity. Put integration and private endpoints in separate subnets. This example uses peered regional VNets so either application can reach either SQL private endpoint during application-only or database-only failover. Define and test the required routes and network controls rather than assuming DNS provides connectivity. Inbound private endpoints and outbound VNet integration.

No Application Gateway is required for this direct Front Door-to-App Service pattern. Add another proxy only for a specific requirement and account for its operational and recovery dependencies.

Numbered request, identity and recovery flows

  1. F1 — Public ingress. Public authoritative DNS points the portal hostname to Front Door. HTTPS requests encounter the associated WAF policy before origin routing; authenticated responses are not publicly cached.
  2. F2 — User authentication. The portal uses Entra authentication and application authorization. Authentication traffic is distinct from the Private Link path; WAF does not authorize access to orders.
  3. F3 — Origin selection. Front Door selects the healthy primary origin, with the secondary at lower priority. Each origin has its own approved regional Private Link connection.
  4. F4 — Primary inbound path. The primary managed endpoint forwards HTTPS to the West Europe production app. Origin host and TLS configuration must match.
  5. F5 — Secondary inbound path. The North Europe managed endpoint reaches the secondary production app without reopening public origin access.
  6. F6 — Primary outbound path. The primary app uses its delegated VNet integration subnet to reach private dependencies.
  7. F7 — Secondary outbound path. The secondary app has an independently configured integration subnet and tested dependencies before it receives users.
  8. F8 — Regional dependency routing. Primary integration traffic reaches approved SQL and vault private endpoints; explicit egress policy covers other required application dependencies.
  9. F9 — Cross-region dependency routing. The secondary VNet can reach the primary SQL endpoint over peering. Test the reverse path too; application and database primaries need not move together.
  10. F10 — Primary data access. The private SQL endpoint delivers connections to the primary logical server. Vault access uses its separate endpoint and permissions, not the SQL endpoint.
  11. F11 — Secondary data access. The secondary SQL endpoint provides the corresponding path after database failover. Its vault and managed identity remain independently provisioned.
  12. F12 — Database replication. The failover group asynchronously replicates selected user databases to the other logical server. This is a managed service path, not traffic forwarded through the app integration subnet.
  13. F13 — Listener resolution. Applications use the failover group’s read/write listener hostname. DNS follows the current primary and resolves its private endpoint using the shared SQL private zone.
  14. F14 — Consistent deployment. A reviewed pipeline deploys the same immutable application artifact and compatible configuration to both regions. Deployment authority is separate from runtime identity.
  15. F15 — Telemetry. Both applications emit redacted request, dependency and exception telemetry; platform metrics and resource logs complement it.
  16. F16 — Clean recovery. The recovery team restores an approved backup into a separately assessed recovery deployment and validates integrity before changing production routing.

SQL, DNS and identity decisions

Follow the documented paired-region Private Link setup: nonoverlapping VNets, a private endpoint for each logical SQL server and reuse of the SQL private DNS zone. Link that zone to both application VNets. Use the listener FQDN in connection strings; never pin the active primary’s address in application configuration. Test actual application resolvers, connection pools and retry behavior after a role change. Failover group configuration.

Choose customer-managed failover for this design. Microsoft-managed failover targets qualifying widespread outages; it is not a substitute for an application recovery decision. Planned failover and forced failover have different data-loss implications. Monitor replication lag, but do not convert a recent healthy sample into a guarantee about unreplicated transactions when the primary becomes unreachable. Failover group behavior.

Replicate application data, not assumptions about server configuration. Provision and verify both servers’ Entra administration, access configuration, endpoints and monitoring separately. Review database users and cross-database dependencies; selected database replication does not replicate the surrounding application stack. Active geo-replication scope.

Prefer managed identity to stored SQL passwords. Give each region only its required database permissions and vault access. Regional vault contents are deliberately provisioned and rotated; two vaults are not automatically synchronized. For Linux App Service accessing network-restricted Key Vault references, configure the documented VNet routing. References can cache values for up to 24 hours, so rotation tests must include refresh behavior. Key Vault reference networking and rotation.

Health probes and failure tests

Use a lightweight readiness endpoint that returns HTTP 200 only when the app can serve the intended transaction class. Avoid creating orders or exposing diagnostics from this endpoint. Front Door expects 200 for a healthy probe; if all origins are unhealthy, it can still distribute requests across them. Therefore each app must fail safely with an appropriate unavailable response when required dependencies are down. Front Door probe behavior.

Acceptance test Evidence and failure response
Request each default App Service hostname from an external network Direct public origin access is denied while the portal remains usable
Remove one approved Private Link connection in a test environment Traffic moves through the other region without a public-origin workaround
Stop only the primary app Secondary app reaches the still-primary database over the tested private path
Perform a planned SQL failover Both regional apps reconnect using the unchanged listener; committed test orders remain consistent
Simulate total dependency failure Apps return controlled errors; no unsafe write or authentication bypass occurs
Load-test the secondary alone Measured throughput and latency meet the approved recovery service level
Revoke a test identity permission or rotate a test secret Failure is visible and recovery does not require broad privileges
Restore a known clean backup Schema, business invariants and access controls are verified before promotion

Monitoring, recovery ownership and rollout

Monitor external transaction success, Front Door origin health, WAF blocks, App Service saturation, SQL replication state, connection errors, vault denials and diagnostic-setting drift. Exclude tokens, raw order payloads and secrets from telemetry. Alerts need tested recipients and an independent service-status channel. The related hunts support selected configuration and identity checks; they are not an availability test suite.

The incident commander chooses application traffic moves; the database owner authorizes forced database failover and records possible data loss. Freeze deployments, preserve the incident timeline, verify the surviving region’s dependencies, then measure recovery from the user’s perspective. Control failback deliberately: an origin becoming healthy can make it eligible for traffic again. Keep both regions on compatible application and schema versions. Multi-region deployment considerations.

For compromise, identify a clean point and rebuild trusted configuration before promotion. SQL point-in-time restore creates a new database and has documented location restrictions; it is not an arbitrary cross-region clean-room restore command. Geo-restore requires appropriate backup redundancy, and long-term retention only helps if a suitable backup already exists. Select and rehearse the applicable path instead of assuming the live secondary is clean. Backup restore options and ransomware recovery.

Roll out private DNS and identities first, then each regional app, database replication, the secondary transaction test, and finally public edge traffic. Protect deployment access separately: a private SCM endpoint and reachable controlled runner are required if deployment uses private SCM; Front Door’s managed endpoint is not a deployment network.

Cost and complexity tradeoffs

The price of warm regional recovery is duplicated App Service and database capacity, Front Door Premium, private endpoints, cross-region traffic, backups and monitoring. A smaller secondary lowers steady-state cost but creates capacity risk and a slower recovery dependency. Zone redundancy addresses a different failure boundary from a second region. Optimize measured instance size, telemetry volume and retention after proving acceptance tests; do not remove the tested recovery path merely because the secondary is usually quiet.

Trace the design decisions

Microsoft architecture & product guidance

  1. Secure Azure Front Door Premium origins with Private Link ↗
  2. Connect Front Door to an App Service origin with Private Link ↗
  3. Azure Front Door health probes ↗
  4. App Service private endpoints ↗
  5. App Service virtual network integration ↗
  6. Reliability in Azure App Service ↗
  7. Multi-region App Service architecture ↗
  8. Azure SQL Database failover groups ↗
  9. Configure a SQL Database failover group ↗
  10. Active geo-replication in Azure SQL Database ↗
  11. Use Key Vault references in App Service ↗
  12. Restore Azure SQL databases from backups ↗
  13. Recover Azure SQL Database from ransomware ↗

Inspect operational evidence

Supporting Sentinel queries

These are contextual hunting starters, not end-to-end validation of the architecture. Check each query's source tables, collection scope and limitations.

Query library →