question

sam.ar4925 avatar image
sam.ar4925 asked

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.
replicationcompressionsqlserver-2012
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
KenJ avatar image
KenJ answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.