Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two servers (one publisher and other is subscriber). The replication is succesfully running for a long time. I am using transactional replication with updateable subscription.

Couple of days back I noticed that the records of one table which is being used in both server got deleted. Leaving no clue for me how this happen. There was around 100K rows that were deleted in no time. Could anyone answer me why and how this could happen? Is it there something related to identity management or something?

share|improve this question
Maybe a user or administrator deleted the data...? – Jon Seigel May 27 '13 at 14:03
no.this is not the case. coz i am the only administrator – user2425198 May 29 '13 at 16:36
Okay, I suggest starting by looking at this question here:… – Jon Seigel May 29 '13 at 16:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.