September 23, 2015 at 6:42 pm
1) log reader agent started successfully
2) in the errorlog no errors relevant to the replication
3) sp_replcmds no return rows
4) distribution db is empty ([dbo].[MSrepl_transactions], [dbo].[MSrepl_commands])
why transactions not propagated to distributor? how to diagnoze it?
September 23, 2015 at 7:35 pm
Is this snapshot replication? Replication support only?
When you open the replication monitor and drill into the publication are you seeing any warnings / errors?
Can you simulate a transaction on replicated table to see if it actually gets replicated?
September 23, 2015 at 9:42 pm
Check the snapshot agent - it needs to run to create the initial snapshot. Until that is done, there is nothing for the distribution agent to do - hence nothing in the distribution database.
September 23, 2015 at 11:26 pm
It is transactional replication.
When i test publication with 1-10 articles, then after create publication (without subscriptions), log reader agent start populate tables [dbo].[MSrepl_commands] [dbo].[MSrepl_transactions] in distribution database.
But when i create publication with ~5000 articles it does not :(. and sp_replcmds no return rows... and no errors in errorlog and log reader agent log....
May be exists technical limitation on articles count per publication?
(sory, my english ugly, i know...)
September 24, 2015 at 5:39 pm
Have you checked the snapshot agent - maybe it has an error
September 25, 2015 at 9:07 am
thanx to all.
i does not use snapshot agent. but use initialize subscription from backup option. after turn it on. all worked.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply