Max text replication size

Question

Hi,

Max text replication size , i need to increase it, i have increased it from server property dialog box .i was transfering image datatype where i found problem.now it is working.

1) is it correct to increse it from sqlserver property?

2) please tel me about (-1 vs increasing the value from 65536 on words), which is good?

3)and how much we should increase , what are the pros and cons.

yours sincerely.

Answer 1

http://msdn.microsoft.com/en-us/library/ms179573.aspx Please refer this msdn article. -1 means the maximum size depending on the data type. It is usually better to set it right size than putting it to max size. If you change it to the maximum, it will cause network latency.

Also refer, http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/694ad697-cdeb-4767-8879-a3a85dded2b0 for better understanding.

Also refer,http://www.sqlservercentral.com/blogs/sqlsailorcom/2012/09/18/max-text-replication-size-when-you-might-have-to-care-about-this-number-/

one more : http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/1836cb7d-d78b-4e51-9a97-cb7194df8016

---

Hope it Helps!!

Answer 2

Stan120,

Can you update the posted links live?  Thanks.

---

Kalman Toth SQL 2008 GRAND SLAM
Paperback: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 3

Stan120,

Can you update the posted links live?  Thanks.

---

Kalman Toth SQL 2008 GRAND SLAM
Paperback: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Links are corrected now...

---

Hope it Helps!!