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

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc.

From A to B we have replication. We wanted to change the replication way, because of A is a lightweight server, we don't want to have tons of data there, so after a while we delete old record but we want to keep them on B. SO we tried to mark the tables replication to "Do not replicate DELETE statement", but even after we restarted the SQL Agent, reinitialized everything...

Same as before: If we delete one record from A's T replicated table, we won't see it on B's T.

Weird thing is, if we want to change the replication settings on the table again, it is still set as "Do not replicate DELETE statement".

Thank you

share|improve this question

migrated from Jan 23 '14 at 22:55

This question came from our site for professional and enthusiast programmers.

There are different types of replication. Might be worth adding what type you're using. At a guess, Transacional? – Damien_The_Unbeliever Jan 23 '14 at 10:10
Yes, it is a transactional. – Zui Jan 23 '14 at 12:08

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.