belle’s sql musings

Issue: Length of LOB data to be replicated exceeds configured maximum 65536

Posted in Issues/Troubleshooting by belle on September 22, 2008


Length of LOB data (78862) to be replicated exceeds configured maximum 65536


We published some articles that use varchar(max) and a lot of XML data types for the columns. When we enabled replication, we got the error Length of LOB data (78862) to be replicated exceeds configured maximum 65536


Increase the size that can be replicated. This is applicable for transactional replication only.

EXEC sp_configure ‘max text repl size’, 2147483647

SSMS (excerpt from BOL):

    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Advanced node.
    3. Under Miscellaneous, change the Max Text Replication Size option to the desired value.


BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3056cf64-621d-4996-9162-3913f6bc6d5b.htm

Tagged with:

13 Responses

Subscribe to comments with RSS.

  1. glompix said, on June 4, 2009 at 9:37 am

    Great post. Exactly what I was looking for. Nice and simple. 😉

  2. Eric said, on June 24, 2010 at 8:52 am

    Excellent post. Helped me identify a solution very quickly!

  3. Dave said, on November 9, 2010 at 3:42 pm

    Thanks for posting. Perfectly fixed our problem 🙂

  4. Alex said, on March 21, 2011 at 2:58 pm

    Thank you guys.

  5. Brian Jaramillo said, on April 19, 2011 at 3:29 pm

    Perfect! Thanks for posting.

    *I know this post is a couple of years old, so those of you viewing for the first time should know that this is a good fix for SQL 2005.

    For SQL 2008, you can use also use -1 to remove the limit from the field.


    EXEC sp_configure ‘max text repl size’, -1


  6. Thom Bolin said, on June 20, 2011 at 10:58 am

    Thanks for the simplicity of the post, not a lot of fluff just the facts

  7. Sanjeev said, on October 4, 2011 at 2:58 am

    Nice Job, this help me a lot..!! thanx

  8. andres said, on November 18, 2011 at 1:22 pm

    Excellent!!! Nice and simply!! Solved my prob!!!

  9. Bradley Ball (@SQLBalls) said, on March 19, 2012 at 7:50 am

    Thanks for the post, exactaly what I was looking for!

  10. Mark said, on October 1, 2012 at 9:02 pm

    Doesn’t fix the problem!!!

  11. vinod said, on December 11, 2012 at 2:20 pm

    awesome post. perfect thing

  12. Declan said, on September 9, 2013 at 6:35 am

    excellent thanks for the help

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: