Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Replication not workiing Expand / Collapse
Posted Thursday, January 30, 2014 9:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 20, 2016 2:11 AM
Points: 298, Visits: 1,291
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?


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 ?
Post #1536408
Posted Thursday, January 30, 2014 9:36 AM


Group: General Forum Members
Last Login: Wednesday, January 27, 2016 7:06 AM
Points: 2,657, Visits: 1,657
Yes, there would be a SQL Agent job for it. You only need to generate a new snapshot if you need to reinitialise a subscription, e.g. because a new article has been added to a publication, or because of a replication error - they can be difficult to troubleshoot and so sometimes the 'sledgehammer' approach is to generate a new snapshot (via reinitialising a subscription). Of course, if your publication is huge, it's going to take a long time to generate the snapshot and push it to the distributor and the subscriber so you may want to be a little more surgical in that case.

There's no harm in scheduling a snapshot agent to run every day because it won't do anything other start up and shut down if it determines that no subscriptions need to be reinitialised.

It might be worth your while grabbing a book on SQL Server replication or at least look it up in BOL or find resources on the web.


EDIT: spelling mistakes
Post #1536422
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse