locked
Getting an Error on snapshot Replication RRS feed

  • 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
    Saturday, July 2, 2011 1:53 AM

Answers

  • 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

    • Proposed as answer by Peja Tao Monday, July 4, 2011 7:55 AM
    • Marked as answer by Peja Tao Monday, July 4, 2011 7:55 AM
    Saturday, July 2, 2011 4:45 AM

All replies

  • 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

    • Proposed as answer by Peja Tao Monday, July 4, 2011 7:55 AM
    • Marked as answer by Peja Tao Monday, July 4, 2011 7:55 AM
    Saturday, July 2, 2011 4:45 AM
  • Thank you Brandon

    its usefull


    -Sql Jaadu
    Monday, July 4, 2011 6:45 AM