I am replicating a table A from Server A to ServerB with transactional replication.
Published article has around 1 Billion row with one of date column value InsertedOn< Getdate()-30. Basically we keep around 1 month of data in table
and delete the data older than 1 month by running a job every 10 min. This job deleted data in batch of 50000.
The requirement now is to keep only 1 week of data on subscriber. I can't delete the data older than a week on subscription else replication will throw error that data row
was not found. Ignoring the error will be my last resort.
Can someone throw some more ideas on how this can be achieved?
Online Trainer For SQL DBA and Developer @RedBushTechnologies
with 16 yrs exp.