patternsqlModerate
Length of LOB data (2135980) to be replicated exceeds configured maximum 65536
Viewed 0 times
maximumlength2135980exceedslob65536dataconfiguredreplicated
Problem
I am getting the replication error 'Length of LOB data (2135980) to be replicated exceeds configured maximum 65536'.
sp_configure was previously applied to set it to max value (-1) and a query on sys.configurations confirms that the max value (-1) is in use.
I have tried using a large value for 'max text repl size' rather than max value and turning it off and on again, to no avail.
Is there something else that may be overriding the 'max text repl size' setting or anywhere else I can look?
sp_configure was previously applied to set it to max value (-1) and a query on sys.configurations confirms that the max value (-1) is in use.
EXEC sp_configure 'max text repl size', -1 ;
RECONFIGURE;
GO
select * from sys.configurations
where name like 'max text repl size%';
GOI have tried using a large value for 'max text repl size' rather than max value and turning it off and on again, to no avail.
Is there something else that may be overriding the 'max text repl size' setting or anywhere else I can look?
Solution
This configuration can be changed using Management Studio by right-clicking the server -> Properties -> Advanced tab -> Miscellaneous -> Max Text Replication Size.
Or you may want to try :
Or you may want to try :
EXEC sys.sp_configure N'max text repl size (B)', N'-1'
GO
RECONFIGURE WITH OVERRIDE
GOCode Snippets
EXEC sys.sp_configure N'max text repl size (B)', N'-1'
GO
RECONFIGURE WITH OVERRIDE
GOContext
StackExchange Database Administrators Q#152784, answer score: 16
Revisions (0)
No revisions yet.