November 15, 2007 at 3:13 pm
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.
November 16, 2007 at 3:29 am
Have you tryed re-snapshoting?
November 16, 2007 at 7:10 am
The snapshot job was not found. How do I create an initial snapshot? I don't understand what's happening here?
November 19, 2007 at 9:34 am
there is no snapshot?
November 19, 2007 at 9:45 am
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. ???????
November 19, 2007 at 9:50 am
I still dont understand.
Can you not make the not working subscription for reinsilisation and resnapshot?
November 19, 2007 at 9:59 am
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