Post reply

The concurrent snapshot for publication has not been activated by the log reader agent

  • May 16, 2006 at 7:54 am

    #93913

    Replication newbie here.  I need some help!

    I set up a SQL 2000 server to do transactional replication.   I then created a SQL 2005 subscription.  I had the publisher generate a snapshot.  In the replication monitor under the distributor to subscriber history it says that the concurrent snapshot for publication has not been activated by the log reader agent.  It just sits there & does nothing. I have let it run for over 24 hours with nothing happening.  How do I get the log reader to activate the snapshot?  I must be missing something simple here.

    Thanks!

    John

  • May 16, 2006 at 9:53 am

    #638194

    I am not sure why I had to do this but it worked.  I reinitialized all subscriptions & then the snapshot was regenerated & the subscriber was able to pull it down.

    I still don't understand why the distribution agent wouldn't activate the 1st snapshot generated & allow it to be pulled to the subscriber.  if anyone has any info they can shed on this, it would be greatly appreciated.

     

    Thanks!

    John

Viewing 2 posts - 1 through 1 (of 1 total)

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