After subscription had been marked for reinitialize, a new snapshot was generated.
Log reader and queue reader agents are running.
But when we try to turn on the synchronizing, we're getting the following error:
The concurrent snapshot for publication 'DBName' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publication.
Once we got it synchronizing well(no idea how it was, it just started working without our participation), but because of foreign keys(and unsynchronised part of data) we had to reinit it all from start.
Here is our publication properties:
How to get it synchronising well?
Best Answer
We've figured out the problem and this is a solution