How to add article back to a replication, the destination table is already existing and has data. I think it is previously on the replication but was untagged only from the publication but did not drop the article properly on te subscriber how to sync it

Question

How to add article back to a replication but the destination table is already existing and has data. I think it is previously on the replication but was untagged from the publication and was not drop the article on the subscriber. How to properly sync it. Do I just add article back to the publication and exec sp_refreshsubcriptions we have a pull setup

Answer 1

Hi @Michelle Urbano ,

Thank you for reaching out and welcome to Microsoft Q&A!

Please refer to this article, hope this can help you well!

Feel free to share your issue here if you have any concerns.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications