Post reply

Data Purging Strategy for Subscriber

  • June 1, 2011 at 1:06 am

    #96205

    What is the standard approach for purging records from subscriber database without deleting data from publisher database in merge replication ?

    We are using merge replication between one sql server 2008 R2 database and multiple SQL Server Express R2 databases.

    We have a requirement of purging data from subscriber at some point of time. But we do not want that data to be purged from the publisher. What are the approaches for doing this?

    Any inputs are welcomed.

  • July 5, 2011 at 5:07 am

    #1348180

    So the records are in the publisher and the subscriber but you want to remove them from the subscriber.

    Not sure that's the right thing to do ??

    IS the data not needed on the subscriber but required on the publisher or is it a case that you just don't want the deletes to go through the merge ??

    Dropping the merge triggers will prevent the records from being merge but the deletes will need to be done both ends to avoid some merge errors ?

    Perhaps a little more clarity is required on your requirement

    Graeme

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply