February 24, 2011 at 1:07 pm
Hi.
In transactional replication one way. i was facing issue one is row at the subscriber.
I'm doing experimenting with transactional replication.
I had tableName(Names) columns are sno, name where sno is primary and identity and names is varchar(50).
and i insert some rows in the table upto 5.
I stopped the log reader agent and insert a one row with 6. for checking i queried sp_replcmds and sp_relshowcmds. and sp_repldone and some stored procedure i done wrongly.
now in subscriber 6 is not reflected, after that i add some more rows in the tables. Other commands are reflected at the subscriber. But my 6 rows is not updated.
Could any one help me please, how to replicate this 6 row to subscriber.
Thanks
Kiran
February 24, 2011 at 2:51 pm
It's odd that the row was not caught even though logreader was turned off. Did it possibly get deleted from msrepl_commands / msrepl_transactions or did you execute an sp_repldone? If so that would explain it.
At this point though if you are seeing other data replicate I would recommend deleting the missing row from the published table and reinserting it so that it gets replicated to the subscriber. Or, you could manually insert it at the subscriber as well, which is probably easier. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 16, 2011 at 5:32 am
Please follow the following link,
http://sqlserverreplicationtroubleshooting.blogspot.com/2011/04/how-to-fix-missing-rows-error.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply