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

Troubleshoot SQL Server Always On Availability Groups with SQL LogScout

We experienced several unplanned outages and failovers on our SQL Server Always On Availability Groups. We want to know the root cause to prevent them from happening in the future. How do we identify the root causes of unplanned Availability Group outages and failovers?

Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster - Part 3

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?

Understanding Windows Server Cluster Quorum Options

If you're deploying SQL Server, you are likely running business-critical applications on it and you need to ensure it's protected from downtime and data loss.

Three Mile Island And Your Databases

Grant takes a few lessons for database DR from a nuclear accident in the US.

Choosing Business Continuity Options

Your MTTR

There are a lot of metrics you can track and many ways to use them to improve how you build and manage software. Steve has a few thoughts on MTTR and similar metrics.

Do *not* place TEMPDB on a local disk in a SQL failover cluster

What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails

Configuring Availability Groups in Ubuntu

In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]