November 22, 2010 at 1:12 pm
In Replication monitor -> Distributor to Subscriber history an Action message is having messages like
"Table Sample might be out of synchronization. Rows counts (actual :9, expected 18)".
I configured Transactional Replication without database snapshot & distribution database in Replicated Server, I setup a Push Subscriptions.
How to replicate the remaining values to replicated server???.
November 22, 2010 at 1:19 pm
I configured Transactional Replication without database snapshot
This is most likely the problem. There was most likely changes to the source db between the time you made the copy to initialize without snapshot, and before turning on transactional replication.
You either need to create a new source and push it through and realign the replication, or let it rebuild itself with a snapshot.
Check this for more details:
http://technet.microsoft.com/en-us/library/ms151705.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 22, 2010 at 1:54 pm
Thanks alot for your suggestions.!
Is there any way to find out using scripts, how many transactions are delivered from Publisher to Distributor and Distributor to Subscriber.
Can You suggest a book to find internal troubleshooting of Replication.
November 23, 2010 at 12:50 am
Sharon Kumar (11/22/2010)
Thanks alot for your suggestions.!Is there any way to find out using scripts, how many transactions are delivered from Publisher to Distributor and Distributor to Subscriber.
Can You suggest a book to find internal troubleshooting of Replication.
Hopefully this will help. You can run this on the distributor.
SELECT
da.name
, da.publication
, ma.article
, ds.UndelivCmdsInDistDB
, ds.delivCmdsInDistDB
FROM dbo.MSdistribution_status DS
INNER JOIN dbo.msdistribution_agents da ON da.id = ds.agent_id
INNER JOIN dbo.msarticles ma ON ma.publisher_id = da.publisher_id and ma.article_id = ds.article_id
ORDER BY
UndelivCmdsInDistDB DESC
,publication
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply