SQL 2008 R2 replication issue

• teflonken2010

  SSC Enthusiast

  Points: 188

  More actions

  November 26, 2015 at 6:08 am

  #313383

  Hi, Experts

  having this is issue of replication always failing after a period of time. it keeps giving this error. the size of my database is about 20GB

  any suggestion of what is problem. the error is show below.

  the merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)

  Get help: http://help/MSSQL_REPL-2147201001

  The process could not bulk copy into table '"dbo"."anj_doc"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)

  Get help: http://help/MSSQL_REPL20037

  An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 0)

  Get help: http://help/0

  One or more BLOB columns could not be sent to the server, attempt to recover from the problem failed. (Source: MSSQLServer, Error number: 0)

  Get help: http://help/0

  Communication link failure (Source: MSSQLServer, Error number: 0)

  Get help: http://help/0

  Unspecified error (Source: MSSQLServer, Error number: 0)

  Get help: http://help/0

  Failed to send batch after max errors (Source: MSSQLServer, Error number: 0)

• tindog

  SSCarpal Tunnel

  Points: 4892

  More actions

  November 26, 2015 at 9:32 am

  #1842531

  Is your snapshot configured to use a UNC path? (e.g \\myamazingcomputer\c$\mysnapshotfolder rather than c:\mysnapshotfolder)

  Otherwise it could be an issue with your articles - would suggest carefully checking publisher vs subscriber for differences.

  LinkedIn