Post reply

Snapshot not yet available while replicating

  • May 21, 2007 at 9:32 pm

    #118767

    I'm getting a message from the subscriber which states that the snapshot is not yet available.  It suddenly decided to do that, and it's been working fine for the past few months.  Why would it do that all of the sudden?  Error logging for replication absolutely sucks, is there a setting where you can enable better logging?  The strange thing is that Publisher says all is good and states 1 command sent, but subscriber is not picking it up.  This is in a push subscription.

    When I drop/recreate subscription it works fine again.

    Thanks

  • May 22, 2007 at 8:51 am

    #708095

    Hi,

     In my opinion there is an option called Reinitialize subscription.Instead of dropping and recreating Subscription,u can reinitialize it from the snapshot the next time the Distribution Agent runs

     

    Cheers

    Deepak

    [font="Verdana"]- Deepak[/font]

  • May 22, 2007 at 8:58 am

    #708098

    I tried to reinitialize, but the message still reported "Snapshot not yet available".  Only drop/recreate helped.

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

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