Home Forums SQL Server 2005 Administering Replication not workiing RE: Replication not workiing

  • January 30, 2014 at 9:11 am

    #1684725

    Lempster (1/30/2014)

    MarvinTheAndriod (1/30/2014)

    The Publication that say "The initial snapshot for publication is not yet available." is the one that isn't working.

    Should I reintialise again. Is it worth starting the snapshot agent ?

    Yes! If the snapshot agent is not running then the snapshot will not be created. The subscription may be marked for reinitialisation, but nothing will happen until the snapshot agent runs. Do you have the snapshot agent set to run on a schedule - once per day for example?

    Regards

    Lempster

    I don't beleive so, as the Replication monitor says the Snapshot agent last start time was over a year ago, and according to the view syrchonsation status it is not running now, but my knowledge of replication is very limited. Would there be a job for it if it was scedhuled once a day ?