MSrepl_agent_jobs does not exists

Problem Setting up Transactional Replication in an AlwaysOn Availability Group environment and getting error similar to one shown below: Msg 14262, Level 16, State 1, Procedure sp_MSrepl_track_addjob, Line 57 [Batch Start Line 12] The specified table (‘MSrepl_agent_jobs’) does not exist. MSrepl_agent_jobs is a new table added to Distribution database in SQL 2017 CU6 and SQL
Read More »

The process could not execute ‘sp_replcmds’

SQL Server Transaction LogReader Agent timeout executing sp_replcmds occurs most often when a large transaction(s) are written to the Published database transaction log, or 100s of millions of un-replicated commands from logged index maintenance or changes to replicated tables.  Either problem requires the LogReader to read more log entries than the timeout parameter allows causing
Read More »

Reset topology using “Replication Support Only”

If you need to reset your Replication topology you can quickly rebuild subscribers using the “no initialize” also called “Replication Support Only (RSO)”.  WARNING: These steps are designed to remove ALL of your Replication configuration and settings, recreating with new metadata tables. The RSO option skips the Snapshot data reinitialization phase. It only pushed down new
Read More »

“Replication Monitor could not insert the tracer token”

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 »