effect of changing "Max Text Repl Size" | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

effect of changing "Max Text Repl Size"

Hey Everyone,
I have come across an issue here which I was curious if anyone else would know. We have an issue right now with replication where one of our large html files is being replicated and we’re actually not able to replicate it because it is larger then the default max text repl size of 65536. I know it has a maximum value 2147483647 bytes, but I’m hesitant to change this setting before I know what effects it will have on the following:
  • what effect will it have on current replication jobs
  • what effect (if any) will it have on the data currently being touched by that job
  • Will changing this need to be done when all replication is stopped or will it even effect a replication job if it is currently runing
If anybody has ever changed this value before after a SQL server is up and running in a production environment, please let me know how you approached it. Thanks, Aaron
never had to change it but the documentaion claims that The setting takes effect immediately (without a server stop and restart). Nathan H.O.
I never had changing this on fly and you must test the setting before deploying on production, every setup is a different case. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.