we have seen an issue in replication of one article and business decided that we no longer needs this table for replication .
So we want to skip all the existing transactions of this article using a script and then drop this article from publication.
Do anyone have a script which can identify all the breaking transactions of the article , skip it and then we can drop that article
We can skip errors in Transactional Replication using the Distribution Agent
-SkipErrors parameter or by using the Distribution Agent profile Continue on Data Consistency Errors.
Transactions can also be skipped using
Skipping Errors in Transactional Replication
How to skip a transaction in SQL 2005/2008 Transactional Replication
Brandon Williams (blog |
A Microsoft está realizando uma pesquisa online para saber sua opinião sobre o site Technet. Se você optar por participar, a pesquisa online lhe será apresentada quando você sair do site Technet.