I never really used replication before I joined my current company. We host client databases in our environment and we had a request to replicate a client’s database to them. Our infrastructure group did not want to allow us to replicate directly from production to the client site.
Read more…
I had a support request recently from one of our clients who wanted was trying to replicate our database to a reporting server. One of our legacy tables contains text data and transactional replication was failing with the error
SQL Server can be configured to allow a maximum size, in bytes, of text or image data which can be replicated. This applies to each insert, update, writetext or updatetext statement issued.
The default is 65536 bytes (64k). In our environment, 262144 bytes (256k) would be sufficient. Here is how to change this setting.
Read more…