Year: 2018

Inside Distribution Cleanup Watermark

Chris Skorlinski [MSFT] Inside Replication March 8, 2018

The Distribution database is a cache of undistributed commands that the Distribution SQL Agent jobs are responsible to deliver to their subscribers. This cache is populated by the Publisher LogReader Agent job as new data changes are detected. The primary tables holding the cache of undistributed data is MSrepl_transactions and MSrepl_commands.

LogReader errors ‘Validating publisher’ after AlwaysOn failover.

Chris Skorlinski [MSFT] Product Updates, Try This February 21, 2018

Problem of the day: Transactional Replication was configured on a database in AlwaysOn Availability Group. When the group was failed over to synchronized secondary node Transactional Log Reader stopped working.