Wednesday, March 21, 2012

Failed Replication

I use SQL2000 and Transactional Replication from server A to B. It is
success to replicate the changes in "Add" and "Deleted" records. But, if I
change the record in server A and then find that fails to replicate. In "Log
Reader" in server A, I can see 1 log is delivered but no any changes in
target. It hasn't any error in log.
Then I tried to rename both tables in server A and B and build the
replication again. It's in normal operation. i.e. Add/Change/Delete are also
ok in replication. Once use back the original table name, it fails to do
"update" replication.
Please advise. Thanks.
Tommy,
can you do an update and check the MSrepl_commands table by using
sp_browsereplcmds. Also, have a look at the article properties (elipsis
button) and check the commands section. It might be that somehow NONE has
been set for the updates. Finally, check that there are no triggers set on
the table which are preventing updates.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment