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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Removing a replicated transaction

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-06-15 : 08:25:57
I'm currently having issues with transactional replication.

There is a command which is failing on the subscriber because of a primary key violation. However I have checked the table on the subscriber database and can see no issue. In fact I have been able to manually insert the record myself.

Is there any way for me to remove this command from being replicated over to the subscriber?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-15 : 10:42:05
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-replication/3987/How-to-ignore-error-and-continue-trasactional-replication

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2011-06-15 : 11:01:40
Thanks, are the ignored errors still logged in the error log? Because I want to just make sure that it is only this one error that is skipped, not more. As in if there are more data consistency issues I would like to know what they are even if they are skipped.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-15 : 11:03:26
Add the option, then remove it after this one gets skipped.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -