SQL Server Project

In this project, I performed a complete installation and configuration of Microsoft SQL Server 2022 Enterprise Edition on two Windows Server 2022 nodes, setting up a high availability environment using Always On Availability Groups. The servers were joined to a Windows Server Failover Cluster with a normal quorum configuration. I created an availability group named "SQLServer-AG" with two replicas, configured for synchronous commit mode and manual failover to ensure zero data loss. Automatic seeding was used to replicate three critical databases (CM\_PR1, test, and VirtualManagerDB) between the nodes. I enabled the HADR feature on both SQL instances, configured SSMS for monitoring, and validated synchronization and failover readiness across both replicas. The environment was fully tested to ensure business continuity and disaster recovery capability.