Replication snapshot

  • I've set-up replication which has been working fne, but it was not used for awhile and now replication is now working.

    I'm getting "the initial snapshot for publication 'xxxx' is not yet available" on the publishers agent and snapshot for this publication has become obsolete on the piblisher merge agent.

    I'm running out of things I can try....

    Any information on this matter would be greatly appreciated.

  • Have you tryed re-snapshoting?

  • The snapshot job was not found. How do I create an initial snapshot? I don't understand what's happening here?

  • there is no snapshot?

  • The other 4 subscribers are working fine. The fifth subscriber had no activity for over a month, so when I attempted to re-add it I starting getting these issues with obsolete publication snapshot and no initial snapshot available. I bet if I tried to re-add one of the other subscribers the same thing would happen. ???????

  • I still dont understand.

    Can you not make the not working subscription for reinsilisation and resnapshot?

  • This whole thing started when the one subscriber would not 'sync-up' and without doing a lot of investigation I dropped the subscriber and then re-added it. Dropping and re-adding subscribers worked for me before so I thought I would try it again to resolve this problem.

    When I start the snapshot agent it can't find the job? How do I go about creating another snapshot?

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

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