Will Always On remain uninterrupted while upgrading SQL Server 2019 to SQL Server 2022?

Question

I have two servers running SQL Server 2019 in a primary-secondary Always On configuration, and I want to upgrade them to SQL Server 2022. If I upgrade them separately, will Always On remain uninterrupted?

My plan is to first upgrade the secondary server to SQL Server 2022, then failover the primary role to it and upgrade the original primary server. Will my servers continue running without downtime during this process

Answer 1

Yes, I believe that this will work. But I very much recommend that you set up a test AG with some VMs or similar, so that you can verify that the process works.

Answer 2

Hi @ramazan göksoy,

When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, you can reduce downtime for the primary replica to only a single manual failover by performing a rolling upgrade (or two manual failovers if failing back to the original primary).

Kindly check Upgrade availability group replicas.

Before starting the upgrade, ensure you have full backups of all databases and configurations.

Test the upgrade process in a non-production environment to validate the steps and ensure compatibility with your applications.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.