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

replication issue Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 2:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 3:30 AM
Points: 3, Visits: 57
''replication cannot do anything''

i have Transaction replication with pull subscription.
There is no error in replication showing all success.

below message showing in replication monitor.

The concurrent snapshot for publication 'Publication_name' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publ
Post #1406609
Posted Monday, January 14, 2013 2:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:57 AM
Points: 2,840, Visits: 3,971
yogesh.bhor (1/14/2013)
The concurrent snapshot for publication 'Publication_name' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publ
i think it is self explantory.

first , regenerate the snapshot for 'Publication_name'
second , also check log reader agent job is running


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1406622
Posted Monday, January 14, 2013 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 3:30 AM
Points: 3, Visits: 57
hi,

i have already regenerate snapshot and yes log reader agent is running.

Post #1406625
Posted Sunday, January 20, 2013 2:29 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, October 13, 2014 11:46 AM
Points: 3,087, Visits: 1,436
yogesh.bhor (1/14/2013)
hi,

i have already regenerate snapshot and yes log reader agent is running.

are you still getting the same error message?





My blog
Post #1409309
Posted Monday, February 11, 2013 8:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:13 PM
Points: 124, Visits: 750
try sp_replrestart at publisher on the publication database.
Post #1418468
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse