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

  • October 27, 2008 at 11:38 am

    #890153

    Mohsin Patel (10/27/2008)

    Does this have something to do with replication deciding that the subscription needs to be reinitialised?

    If the subscription gets reinitialised, a new snapshot must be generated. The distribution agent will give that error until a fresh snapshot is available.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass