Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Replication not workiing Expand / Collapse
Author
Message
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: Thursday, August 14, 2014 9:31 AM
Points: 295, Visits: 1,252
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 ?
Post #1536408
Posted Thursday, January 30, 2014 9:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:18 AM
Points: 2,048, Visits: 1,403
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.

Regards
Lempster

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

Add to briefcase ««12

Permissions Expand / Collapse