Getting an Error on snapshot Replication

Question

Dear All,

We configured Snapshot replication on SQL 2005 Sp3. But we are getting the following error please help me to resolve the issue

I have taken the full backup and restored on subscriber and then started the Snapshot replication with default settings

 

The process could not bulk copy into table '"dbo"."table name"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
·    memory mapped file read failed
·    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
·    bcp "my db in subscriber"."dbo"."table name" in "z:\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData\unc\chdatabase_Datta_testREPLICATION\20110701153127\Z_SerialNum72d3d515_245#35.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -STESTsubscriber -T -w (Source: MSSQLServer, Error number: 20253)

 

---

-Sql Jaadu

Answer 1

I believe this is a known issue for SQL 2005 SP3.  Please have a look here:

http://support.microsoft.com/kb/967527

According to the KB article, the fix for this was released in CU3 for SQL 2005 SP3.  Apply SP4 or the latest cumulative update and see if this alleviates your issue.

---

Hope this helps.
www.sqlrepl.com

Answer 2

Thank you Brandon

its usefull

---

-Sql Jaadu