replication issue

  • ''replication cannot do anything''

    i have Transaction replication with pull subscription.

    There is no error in replication showing all success.

    below message showing in replication monitor.

    The concurrent snapshot for publication 'Publication_name' 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 publ

  • yogesh.bhor (1/14/2013)


    The concurrent snapshot for publication 'Publication_name' 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 publ

    i think it is self explantory.

    first , regenerate the snapshot for 'Publication_name'

    second , also check log reader agent job is running

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • hi,

    i have already regenerate snapshot and yes log reader agent is running.

  • yogesh.bhor (1/14/2013)


    hi,

    i have already regenerate snapshot and yes log reader agent is running.

    are you still getting the same error message?

  • try sp_replrestart at publisher on the publication database.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply