June 12, 2012 at 8:00 am
we have Transactional replication already setup from 199 articles using the initialize backup option which is running fine and I if i need to add one article i use the sp_addarticle and run the snapshot agent which used to work fine.
Yesterday I again got to add an article and followed the same procedure... but ended up with the below error in the distribution agent log in the replication monitor
The concurrent snapshot for publication xxxx 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 p....
any help folks ?:(
June 12, 2012 at 8:35 am
Start the logreader agent?
Jared
CE - Microsoft
June 12, 2012 at 9:05 am
not yet ... after i saw the message above i monitored the replication for 1 hour.. saw no progress in the replication monitor screen....so dropped the article I have added using the snapshot... replication started delivering the commands....
do I need to restart the log reader agent before or after the snap shot agent ?
June 12, 2012 at 9:09 am
AK1516 (6/12/2012)
not yet ... after i saw the message above i monitored the replication for 1 hour.. saw no progress in the replication monitor screen....so dropped the article I have added using the snapshot... replication started delivering the commands....do I need to restart the log reader agent before or after the snap shot agent ?
I believe that when adding an individual article without creating a snapshot, you have to start the reader after it has stopped. I have to look back at my notes, but I think that is how we treat manual syncs without creating a snapshot.
Jared
CE - Microsoft
June 12, 2012 at 9:41 am
Thanks for the reply.. Will give a shot and update the post...or will comeback if could not add the article.... 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply