[Epic] SQL Server HA on Azure Local Full Build-Out

[kristopherjturner]

[Epic] SQL Server HA on Azure Local Full Build-Out

Deliver production-ready IaC, tooling, and documentation for running SQL Server High Availability (Always On AG and FCI) on Azure Local.

Scope Boundaries

• Always On Availability Groups on Azure Local
• Failover Cluster Instance with S2D shared storage
• SQL Server Arc extension and Azure Monitor integration
• Out of scope: cloud-only Azure SQL, SQL Managed Instance

Hard Close Gate

1. IaC templates tested and merged to main
2. CI/CD pipelines passing
3. All sub-tasks closed
4. Documentation published

Child Workstreams

• feat: Always On Availability Groups automated deployment #1 feat: Always On Availability Groups automated deployment
• feat: Failover Cluster Instance (FCI) configuration #2 feat: Failover Cluster Instance (FCI) configuration
• feat: SQL Server Arc extension and Azure Monitor integration #3 feat: SQL Server Arc extension and Azure Monitor integration
• feat: backup strategy and Azure Backup integration #4 feat: backup strategy and Azure Backup integration
• infra: CI/CD pipelines (lint, test, release) #5 infra: CI/CD pipelines (lint, test, release)
• docs: documentation and operational runbooks #6 docs: documentation and operational runbooks

Cross-Repo Dependencies

• �zurelocal-toolkit#4 — variable registry
• �zurelocal-toolkit#5 — IaC maturity tracking

References

• SQL Server on Azure Local
• azurelocal-sql-ha repo

[kristopherjturner]

Tracked in Azure DevOps: https://dev.azure.com/hybridcloudsolutions/Azure%20Local%20SQL%20HA/_workitems/edit/124