Home Forums SQL Server 7,2000 Replication Initial snapshot for publication is not yet available RE: Initial snapshot for publication is not yet available

  • HI All,

    I also faced the same error once. This is raised if the distributor retries to connect the subscriber few times and markes with this error.

    To resolve this what I followed are;

    stop the agent first.

    right click on publication and start the snapshot agent.

    Once it sompleted, now you start the distribution agent.

    It will reinitialize the subscriber and problem gets solved.

    This is ok for few records or with high banded network connection. But for huge records about millions of records then it will affect all other groups.

    So I am trying with new option, if i could succeeded I will post the steps i followed.

    regards,

    Tharves