question

Jagadeesh21 avatar image
Jagadeesh21 asked

truncate replicated table in SQL Server

Next:

Query hanging on 2 specific columns

Hi,

We have multiple tables in transnational replication, from SQL to SQL, and version is 2012.

User wanted to truncate one table(16M Rows) and load the data newly which is part of trans replication.

And replication is configured for the same table from Prod to QA, and QA to Dev, so replication should not disturb from QA to Dev when we truncate/remove and re-add the table from prod publication

We have minimal time to do so..

Steps we know ..

1. Drop/Remove the article from Publication

2. Reinitialize subscription

3. Truncate table

4. Add the article again into replication with snapshot of single article

-- Issue is at step 2, we don't want to reinitialize the replication which will take around 5 hours .

Please suggest best approach and steps to Remove and Add same replicated table without reinitialize subscription from Prod-QA-Dev

sql server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.