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.

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 stackoverflow.com Jan 23 at 22:55

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

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

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.