Post reply

replication

  • April 18, 2019 at 11:42 am

    #3449374

    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?

  • April 18, 2019 at 2:33 pm

    #3451646

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

    Sue

  • April 18, 2019 at 4:51 pm

    #3454207

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

    Dropping article will invalidate snapshot.

    • This reply was modified 5 years, 8 months ago by  rVadim. Reason: Corrected myself

    --Vadim R.

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

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