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. It's 100% free, no registration required.

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?