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.
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.
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.
SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?
A client’s database always showed AVAILABILITY_REPLICA in log_reuse_wait_desc of sys.databases. After quick research, here is what it means and how to fix it.
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.