Version: SQL Server 2014 (Web edition)
Replication: Transactional

Came across an odd issue whereby the replication pull job on 10 of our 45 subscribers stopped running when removing article from corresponding publication.

This was completed through the GUI and didn't see any errors in distributor's SQL log.

Any ideas?


I don't know how your drop the article from publication, but you can assign again just execute this

exec sp_addsubscription @publication='your_pub',@article='all',@subscriber='your_server'
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.