The Mythical Bus Accident

Preparing for disaster is important, both at work and in your personal life.

Correct SQL Server Always On Availability Group Not Synchronizing

We had an issue with a SQL Server database in an Always On Availability Group (AOAG) where it was not synchronizing the secondary replica even though it was using the “Synchronous commit” Availability Mode for the secondary replica. This article explains how to troubleshoot and resolve:

Add New Disk to Windows Failover Cluster for SQL Server

I have a 2-node failover cluster instance running on Windows Server 2019 Standard edition. I have a requirement to add a new SAN disk to the SQL Server failover cluster instance (FCI), and then I need to move a user database to that newly added shared disk. Can you show the steps required to add a new disk to the FCI and move the user database?

Add Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster

I used the guide in a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 to install a SQL Server 2008 on a Windows Server 2008 failover cluster (WSFC). Now, I would like to upgrade and migrate my SQL Server 2008 failover clusters to SQL Server 2022 running on Windows Server 2022. What is the process for installation and configuration?

Do You Really Need HA?

Steve asks the question about whether or not a particular environment really needs HA implemented.

SQL Server 2022 Clusterless Distributed Availability Group

This article shows the final step of an availability group creation, specifically for a distributed clusterless one.

Removing Log Shipping

The Monitor Server

Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)

Setting up High Availability in SQL server has some prerequisites. One of these is that the database servers must be members of the same Windows Server Failover Cluster. In this article I show how to succesfully set up WSFC and activate Cluster Aware Updating

The Secondary Database Name in an AG