Skip to main content

Posts

Showing posts from July, 2019

The concurrent snapshot for publication is not available because it has not been fully generated or the Log reader agent is not running to activate it.

Hi everyone. Welcome to my first post. In my environment, we still utilize replication. What in the world is replication? Replication is a way to copy data from your source to destination server continuously. Imagine if I am adding records to a database on your source server throughout the day and I would like the data updated to the target server. That's what is possible with replication. Here's a great article for further reading: https://www.sqlshack.com/sql-server-replication-overview-of-components-and-topography/ Back to the issue at hand. 1. After reinitializing replication on the QA server, I received this message under the replication monitor > Distributor To Subscriber History: The concurrent snapshot for publication is not available because it has not been fully generated or the Log reader agent is not running to activate it. This was the other error message I was receiving under the replication monitor > Publisher To Distr...