Posted on 2006-05-02
I had push transactional replication (with immediate updating subscribers) running without any problems for a few weeks. All of a sudden, with no apparent reason, synchronization between publisher and subscriber stopped working. This is the second time this has happened during the course of my testing.
Subscriber's status shows "The initial snapshot for for publication 'xxx' is not yet available.
This is a strange situation because:
1) An initial snapshot had already been generated which was used to initialize the subscriber
2) Synchronization was working well and now it seems that (with the status message above) the subscriber is waiting to be (re)initialized?
3) Transactions performed on either the publisher or the subscriber are successfully delivered to the distribution database, but the transactions are never delivered by the distribution agent to the intended recipients (publisher or subscriber)
I need to know why this is happening and how I can avoid this behavior in the future.
Extra 500 points will be given to anyone who can nail this issue.