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 […]

Keeping Availability Group Logins in sync automatically

I am Andreas Schubert and I am working as a Princi...

SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group

While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group....