Take the 2-minute tour ×
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?

share|improve this question
1  
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: dba.stackexchange.com/questions/4269/… –  Jon Seigel May 29 '13 at 16:43

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.