Do not rename the distributor_admin login on a server that uses replication. This post shows how to check whether replication uses it, and a loopback demo with a throwaway login that shows what a rename breaks.
What is Transactional Replication Supported Version Matrix? – Interview Question of the Week #274
Question: What is the Transactional Replication Supported Version Matrix?
The rules for the supported versions are pretty simple and clearly written.
Error 9002: Transaction Log Full Due to REPLICATION
A transaction log full due to REPLICATION put error 9002 in a client’s ERRORLOG. The database showed no replication at all. The cause was a leftover publication with no subscriber, and here is how we cleared it and shrank the log.
SQL SERVER – Error 21028 : Replication Components are not Installed on This Server
After I set up AlwaysOn for a client, configuring replication failed: Replication components are not installed on this server. Here is how to fix error 21028.
Log Reuse Wait Reason AVAILABILITY_REPLICA: What It Means and How to Fix It
A customer’s database always showed AVAILABILITY_REPLICA as the log reuse wait reason in sys.databases. Here is what it means and three causes to check: a slow network, a long running transaction and a resource constraint.
SQL SERVER – Scripts to Overview HADR / AlwaysOn Local Replica Server
SQL Server expert Dominic Wirth shares a script that gives a utilization overview of the local AlwaysOn replica server: database count and size, by role and group.
SQL SERVER – Unable to Remove Replication Publication – Could not Delete the Subscription at Subscriber ‘SubServer’ in Database ‘SubDB’
On my broken replication lab, removing a publication failed with: Could not delete the subscription at Subscriber ‘SubServer’. Here is the command that fixed it.