sql server replication:
hi,
Currently, I did a merge replication for BLOB. if the blob column
size less than 495MB, the synchronization is ok. if size more than
495MB, the synchronization will be failure. Does anyone has this kind
problem in merge replication?
The detail information of my merge replication are:
1. Server: windows 2003 R2 64bit, 4 CPUs and 16GB RAM
2. Microsoft SQL Server 2005 SP2 (9.0.3159) enterprise edition
3. in this test, the publication and subscriber on the same server
4. article: one artilce with varbinary(max) column
5.@stream_blob_columns='ture'
6.during test, if insert data to varbinary(max) column from file with
more than 495MB, the synchronizatin will be failure. the error message
is:
2007-10-15 18:32:03.926 The merge process could not enumerate changes
at the 'Subscriber'. When troubleshooting, restart the synchronization
with verbose history logging and specify an output file to which to
write.
2007-10-15 18:32:03.926 OLE DB Distributor 'RLU\LOCALZIMS': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2007-10-15 18:32:03.986 The Merge Agent was unable to update
information about the last synchronization at the Subscriber. Ensure
that the subscription exists at the Subscriber, and restart the Merge
Agent.
2007-10-15 18:32:04.166 Percent Complete: 0
2007-10-15 18:32:04.166 Category:NULL
Source: Merge Replication Provider
Number: -2147200999
Message: The merge process could not enumerate changes at the
'Subscriber'. When troubleshooting, restart the synchronization with
verbose history logging and specify an output file to which to write.
2007-10-15 18:32:04.176 Percent Complete: 0
2007-10-15 18:32:04.176 Category:SQLSERVER
Source: RLU\LOCALZIMS
Number: 0
Message: Unspecified error
2007-10-15 18:32:04.186 Percent Complete: 0
2007-10-15 18:32:04.196 Category:NULL
Source: Merge Replication Provider
Number: -2147199481
Message: The process was successfully stopped.
regards
Rlu
