We are working on purging data in 3.5 TB database which is acting as a publisher in Merge replication with 2 subscribers which are hosted on EC2 machines in Europe and US regions respectively. We are looking for a Data Archival Strategy to optimize the data sync between publisher and subscribers in the best possible way as the volume of records that are going to be purged in publisher will be in millions.

This huge data purge in publisher will choke the subscribers and might delay the data sync from days to weeks. Hence we are looking for some recommendations on the archival strategy.

​We are working on purging data in 3.5 TB database which is acting as a publisher in Merge replication with 2 subscribers which are hosted on EC2 machines in Europe and US regions respectively. We are looking for a Data Archival Strategy to optimize the data sync between publisher and subscribers in the best possible way as the volume of records that are going to be purged in publisher will be in millions. This huge data purge in publisher will choke the subscribers and might delay the data sync from days to weeks. Hence we are looking for some recommendations on the archival strategy.  Read More

​