We have an operational database that keeps 30 days worth of data and a reporting database that has a window of 120 days of data.
Transactional replication is keeping the reporting DB insync with the operational DB very well for the 30 day window. The problem is when we purge the old 30 days of data from the operational side, we will lose it from the reporting side as well. We want
the reporting side to not delete the purge records. What are my options for not allowing the purge delete from replicating to the reporting side? Is there a white paper on this subject somewhere?
Our DBA is telling us we can't solve this issue due to our replication of the 30 day window.