April 18, 2019 at 11:42 am
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
One option would be to drop the article from the publication, delete the data and then add the article back to the publication.
Hall of Fame
April 18, 2019 at 4:51 pm
Another options is to delete in smaller chunks over period of time.
Dropping article will invalidate snapshot.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply