• You can configure transactional replication not to replicate delete actions.

    When you add the article to the publication, specify 'none' in the delete command stored procedure.

     

    @del_cmd  = 'NONE 'parameter if you are using sp_AddArticle stored procedure, or from EM in the properties of the publication, in the articles tab and then in the commands tab.