#availability groups

[sparkidoo]

SQL Server Availability Groups are the only Microsoft-supported high-availability path for SharePoint Subscription Edition — and the seeding sequence is unforgiving. This post walks SQL DBAs and SharePoint architects through every prerequisite, the complete backup → NORECOVERY restore → AG join work

Adding SharePoint Content Databases to a SQL Server Availability Group: The Correct Seeding Sequence

[thedbahub]

How to Easily Sync Stored Proc Changes Across SQL Server AG Replicas

Introduction Have you ever made changes to stored procedures on your primary SQL Server Availability Group (AG) replica, only to realize those changes didn’t automatically propagate to the secondary replicas? It’s a common issue that can lead to inconsistencies and confusion. In this article, I’ll share the best way I’ve found to easily synchronize stored proc changes across all your AG…

View On WordPress

[thedbahub]

Choosing Between Failover Cluster Instances and Availability Groups in SQL Server

In SQL Server, high availability and disaster recovery are crucial aspects of database management. Two popular options for achieving these goals are Failover Cluster Instances (FCIs) and Availability Groups (AGs). While both technologies aim to minimize downtime and ensure data integrity, they have distinct use cases and benefits. In this article, we’ll explore scenarios where Failover Cluster…

View On WordPress

[eitanblumin]

Forced Quorum Mode and The Value of Democracy

#AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Check out this real-life scenario involving DR exercises and quorum failures. #Microsoft #SQLServer #HADR #Blog #MadeiraData

In a recent incident involving AlwaysOn Availability Groups, an interesting lesson was learned about cluster configurations and the delicate balance of democratic votes within them. The scenario occurred during a routine DR exercise, where a client’s entire cluster collapsed unexpectedly, prompting an investigation into the root cause. As it turned out, the issue stemmed from the cluster…

View On WordPress

[eitanblumin]

What is not contained in contained Availability Groups

What is not contained in contained Availability Groups? #Microsoft #SQLServer #HADR #MadeiraData #AlwaysOn

While being an awesome feature introduced in SQL Server 2012, Availability Groups were always missing the ability to synchronize server-level objects between replicas. This finally changed 10 years later, in SQL Server 2022, with the introduction of “Contained Availability Groups”. (more…)

View On WordPress

[eitanblumin]

T-SQL Tuesday 143 - Short Powershell code to move DB files in AlwaysOn

This month's #tsql2sday is hosted by John McCormack (@actualjohn) who asks us to share some useful snippets of code that can help us in our every-day jobs. And today: a #Powershell code to move DB files in AlwaysOn #HADR. #SQLServer #MadeiraData

This month’s #tsql2sday is hosted by John McCormack who asks us to share some useful snippets of code that can help us in our every-day jobs. Well, honestly, this is more or less what my blog is mostly about anyway – sharing insights, scripts, and code snippets that I found to be helpful in my day-to-day job as a SQL Server consultant. (more…)

View On WordPress

[eitanblumin]

Feature Request - Expand MSX/TSX Capabilities for HADR

[New #Blog Post] Feature Request to Expand #SQLServer MSX/TSX Capabilities for #HADR

Following my presentation of “How to HADR Your SQL Server Jobs” at the HA/DR PASS Virtual Group yesterday, David Klee (@kleegeek) and I continued chatting for a bit longer after the recording was concluded. During which, the MSX/TSX feature of SQL Server came up, and David suggested that I’d utilize my newly earned MVP status to push a feature request to expand these capabilities.

(more…)

View On WordPress

[eitanblumin]

Control SQL Jobs based on HADR Role - Taking it to the Next Level

[New #Blog Post] Bam! Let's knock it up a notch! Enable or Disable #SQLServer Jobs Based on HADR Role - Taking it to the Next Level! #Microsoft @SQLServer #MadeiraData

In one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for automatically enabling or disabling scheduled jobs in combination with Availability Groups and Database Mirroring. In this blog post, I’m going to build upon my previous solution and improve it even further – taking it to the next level of automation!

(more…)

View On WordPress