How to enable Data Compression in SQL Server transaction Replication on Subscriber only?
I have a transactional replication setup and i want to enable data compression(page or row) only on the subscriber side. I tried setting this up and it works fine until you reinitialize the subscriber. Every time i reinitialize the subscription it wipes out the compression setting and set it to default(none). Just to be clear....publisher and subscriber are both SQL 2012 enterprise. If anyone experienced this before or know any solution please share with me. Thanks in Advance.
Any table-level customizations to the subscriber database tables (custom indexes, compression, filegroup placement, etc) are always overwritten by their publisher counterparts whenever a subscription is reinitialized. You will have to re-enable compression on the subscriber tables each time the subscription is reinitialized