I have setup push transaction replication. Last week the new snapshot was taken and was delivered to the subscriber successfully but now it is again showing this message - The initial snapshot for publciation is not yet available.
Can anyone tell me why every week I get this message? Shouldn't it be one time process unless any change made to the publication. Nothing changed so far.
Again, the snapshot issue 'Snapshot is not available' even after running the snapshot agent just 3 days ago. Can someone please help me? I can't everytime reinitialize the subscription. There must be some setting which I am missing.