How to add article back to a replication, the destination table is existing and has data. How do you sync it

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

How to add article back to a replication but the destination table is already existing and has data. I think the article was on the replication before but just untagged from the publication and did not drop the article properly on the subcriber. How to sync it correctly. Do I just add article back to the publisher and exec sp_refreshsubcriptions? We have a pull subscription

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,759 questions
0 comments No comments
{count} votes