June 7, 2024, 10:19 p.m. | Shekhar Tarare

DEV Community dev.to




Understanding the Error


The error indicates that the LOB data size (78862 bytes) exceeds the configured maximum limit (65536 bytes) set for replication in SQL Server. This typically happens during the replication process, leading to the failure of data transfer.





Common Causes




  1. Default Configuration Limits: SQL Server has default settings for the maximum size of LOB data that can be replicated.


  2. Large Data Inserts: Inserting large multimedia files or extensive text data can exceed the default LOB size limit.


  3. Inadequate …

configuration data database error failure maximum process replication server set sql sqlserver transfer tutorial understanding

Senior Data Engineer

@ Displate | Warsaw

Junior Data Analyst - ESG Data

@ Institutional Shareholder Services | Mumbai

Intern Data Driven Development in Sensor Fusion for Autonomous Driving (f/m/x)

@ BMW Group | Munich, DE

Senior MLOps Engineer, Machine Learning Platform

@ GetYourGuide | Berlin

Data Engineer, Analytics

@ Meta | Menlo Park, CA

Data Engineer

@ Meta | Menlo Park, CA