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

Michelle Urbano 40 Reputation points
2024-07-02T21:13:18.8333333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,267 questions
0 comments No comments
{count} votes

Accepted answer
  1. LucyChenMSFT-4874 2,985 Reputation points
    2024-07-03T05:34:46.9666667+00:00

    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

    0 comments No comments

0 additional answers

Sort by: Most helpful