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
2021-01-04
5,536 reads
HA/DR/AG/FCI/Clustering/Business Continuity
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 […]
2020-08-25
1,526 reads
Keeping Availability Group Logins in sync automatically
I am Andreas Schubert and I am working as a Princi...
2019-05-22
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....
2019-05-10
Blogs
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our...
Data Mesh: Centralized ownership vs decentralized ownership
By James-Serra
I have done a ton of research lately on Data Mesh (see the excellent...
Daily Coping 23 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Define All The Steps Up Front
Comments posted to this topic are about the item Define All The Steps Up...
Having users access .dtsx (package file) saved on LAN
Hello All, I created a package file (.dtsx) via SSDT. I took the folder...
AG is continually reporting failover due to mirroring connect error
Hello experts, I'm seeing this Always On Availability Group behavior around every 5 minutes....
Ask SSC