Replication not happen for 1 table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Replication not happen for 1 table

Author

Topic

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2010-08-18 : 20:19:26

Hi,

Replication was running fine. All of suddent 1 table is unable to replicate.The meessage as below:
Error messages:
The process could not bulk copy into table '"dbo"."ACCURACY_CHK"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
End of file reached, terminator missing or field data incomplete
To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
(Source: MSSQLServer, Error number: 20253)

Please advice.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-19 : 09:31:22

this is transactional replication?

what versions are publisher, distributor, subscriber?

is the distributor on the publisher or is it dedicated?

this error occurred after you initialized without snapshot? if so, you probably need to recreate ACCURACY_CHK at the subscriber. or run snapshot and resynch