• rk1980factor


    Points: 1681

    How can we delete 12 million rows from a table on a production instance that is transactionally replicated to another instance on the system without overwhelm the replication process?

  • Sue_H

    SSC Guru

    Points: 90671

    One option would be to drop the article from the publication, delete the data and then add the article back to the publication.


  • rVadim

    Hall of Fame

    Points: 3969

    Another options is to delete in smaller chunks over period of time.

    Dropping article will invalidate snapshot.

    • This reply was modified 1 year, 1 month ago by  rVadim. Reason: Corrected myself

    --Vadim R.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply