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: publication properties

How to get it synchronising well?

  • We found a message in LogFileViewer: Replication-Replication Transaction-Log Reader Subsystem: agent Computer-Name-DBName-1 scheduled for retry. The process could not execute 'sp_replcmds' on 'Computer-Name'. – arena-ru Nov 30 '10 at 12:34

We've figured out the problem and this is a solution

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.