Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2008-10-28 : 16:34:11
|
| I have suddenly started getting this errors which is stopping from data being pushed to Subscriber.Is there any way troubleshoot this errors, since this is pretty generic for al DMLs that are not getting pushed to subscriber.Replication-Replication Distribution Subsystem: agent NV-DEVSQL2 Test-TestPI-NV-DEVSQL4-14 failed. The row was not found at the Subscriber when applying the replicated command.Any suggestions and inputs will helpThanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 16:55:19
|
| Did you restore subscriber database from backup and tried to Resync? |
 |
|
|
amsqlguy
Yak Posting Veteran
89 Posts |
Posted - 2008-10-28 : 17:01:22
|
quote:
Originally posted by sodeep
Did you restore subscriber database from backup and tried to Resync?
I restored from the backup and set up the replication, it worked fine for couple of hours. I did not try to resync it is there any to check if it was indded trying to resyncThanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
amsqlguy
Yak Posting Veteran
89 Posts |
Posted - 2008-10-28 : 20:30:08
|
| sodeep Thank you for the reply from the forum link"I added -skiperrors 20598 parameter to the agent properties and then started synchronizing distribution agent and looks like replication worked. I can see transactions replicated to subscriber database."where do we add "-skiperrors 20598 parameter" parameter in sql server 2005 Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 00:18:45
|
| http://msdn.microsoft.com/en-us/library/ms151331.aspx |
|
|
|
|
|
|
Transaction Replication Error