SQLTeam.com | Weblogs | Forums

How to handle the situation in transactional replication?


#1

Hi, can anyone please help me. I have a transaction replication i want to replicate all the transaction to the replication server except for delete transaction. How would I be able to handle this situation?


#2

You would specify that in the article properties. Just unselect the delete option.


#3

Take a look at this informative article https://www.mssqltips.com/sqlservertip/2520/options-to-not-replicate-sql-server-delete-commands/ this will show you step by step methods to not replicate SQL Server deleted command