AlwaysOn

Building a SQL Server 2025 Lab on Linux Part 3: Installing SQL Server and Creating the Windows Cluster

In parts 1 and 2, we laid the foundation for a SQLLab. We figured out how to use virt-manager to create a Windows Server 2025 lab copmposed of 4 virtual machines on a Linux Mint host. Here is what I built. Machine IP Address Purpose DC01 …

Continue reading

My Availability Group Database Isn't Synchronizing

I currently manage 5 AlwaysOn Availability Groups. Two are on SQL Server 2014 and overdue for an upgrade, while three of them are on SQL Server 2017. From time to time I have run into a couple of different situations that I needed to troubleshoot and …

Continue reading

Lessons Learned Updating to SQL Server 2017 AlwaysOn Availability Groups

In late 2019, a project that had been in progress for well over a year finally came to a conclusion. I had collaborated with a number of people to migrate a stand alone SQL Server 2008 and two stand alone SQL Server 2008 R2 instances. Each stand …

Continue reading