New answers tagged high-availability
I resolved this in the end. It was my own fault. I had connected using the name of the cluster "SQL-CLUSTER" rather than creating a listener. Originally I had tried to create a listener but was getting errors so stupidly I'd just ignored them. The errors were because I'd not set up the network properly (I'm a DBA not a network technician :) ) Anyway, after ...
What about putting the Distributor in an AlwaysOn Availability Group of it's own on two different servers and make the secondary a synchronous replica? Besides, there's real benefit in a high volume OLTP environment to not having the Distributor on the same SQL Server.
Top 50 recent answers are included