SQL Server 2012 supports Managed Service Account (MSA) is a special type of domain account assigned to a single computer used to manage a service like SQL Server, but no passwords to remember! SQL Server 2014+ support group Managed Service Account (gMSA) provides the same functionality within the domain but also extends that functionality over
Read More »
ecently I posted Repltalk a walkthrough setting up Publisher, Distributor, and Subscriber each in AlwaysOn Availability groups. In this series of postings, I’m going to break then, show you what went wrong, and how to fix it. Let’s start with error message when attempting to validate a redirected publisher. USE distribution; GO DECLARE @redirected_publisher sysname;
Read More »
UPDATE: 4/10/2020 The steps below walk through setting SQL Server 2016 Replication Publisher, Distributor, and Subscriber each in an Always On Availability Group with one set of replicas residing one 1 subnet and 2nd set on another subnet simulating 2 different data centers (Pub1, Dist1, Sub2) <–> (Pub2, Dist2, Sub2). More Information: Configure replication with
Read More »
I’m seeing an uptick in customers using combination of AlwaysOn and Transactional Replication. Some are configuring the Publisher for high-availability, and some are configuring the Subscriber with Read-Only Secondary to prevent contention from the Distribution Agent updates and “reporting” read queries. Once configured, Tracer Tokens are often used to monitor end-to-end Transactional Replication Latency. Tracer
Read More »
While troubleshooting SQL Server Replication we often want to capture detail step-by-step execution of Replication Agent. One technique is to configure the Agent to log its execution to a Text file. This posting walks through a couple of different ways to accomplish this. It is also covered in the KB article http://support.microsoft.com/?id=312292. I’ll use both
Read More »