Subtitle – Distributed AG, the Gift That Keeps on Giving Overview Unexpectedly, we had a connection timeout/failure between a couple of nodes of our Availability Group (AG). None of the documented causes of this (that we could find) were responsible for this, until somebody asked a very simple question….
Moving TempDB files isn’t as painful as some people would lead you to believe.
Creating a Distributed AG can have some issues. This article covers the problems that we encountered.
Duplicating an AG to another environment, for migration purposes.
Overview For a future article, I require a Listener for the Availability Group (AG) that was created from this article. This post describes the simple steps required to create a Listener.
Background For some investigative work that I had to do, I required an Availability Group (AG) that I could destroy and rebuild without impacting anybody else. Hyper-V was an obvious solution and this article describes the steps required.
Background Whilst reading up on the finer details of High Availability Groups (HA Groups) I have discovered that it can, under certain circumstances, use Snapshot Isolation Level and therefore, row versioning. This has implications with your monitoring and maintenance tasks.
Background Because one of the nodes in our AG was having Windows updates applied, it was necessary to suspend data movements for all databases involved in the AG, on that server. Upon my return (after the maintenance was completed) I was unable to connect to the server, with a message that didn’t really match the …
Notes on SQL 