replication

  • rk1980factor

    SSCommitted

    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: 89702

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

    Sue

  • rVadim

    Hall of Fame

    Points: 3735

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

    Dropping article will invalidate snapshot.

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

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

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