[SQLDownUnder] SQL Server 2005 Transaction Replication

[Michael van der Veeke]

Good morning everyone,

 

We have just moved our SQL server replication from one server to another for various reasons, but now when we try to apply a snapshot (which is 49GB in size) we are getting the following error:

 

************************ START

 

Error messages:

·          The process could not bulk copy into table '"dbo"."tblPodImages"'. (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 "BexWebSite2005"."dbo"."tblPodImages" in "\\sierra\SQLReplication$\unc\SUPRA_TS2000_IMAGES_TS2000_IMAGES - 31 TO 120 DAYS\20070831095033\tblPodImages_2.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -SWEBDB -T -w (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253

 

************************** END

 

Now our configuration is this:

 

Publisher (Supra) is a 2005 Enterprise edition running on a clustered environment

Distributor (Sierra) is a 2005 Enterprise edition running on a clustered environment

Subscriber is (webdb) is 2005 Enterprise edition on a normal windows 2003 machine.

 

Now this used to work very successfully until we placed ISA Server 2006 in as our proxy.  I have searched on google to try and find an answer with no success.

 

Any suggestions are greatly appreciated. 

 

Regards,

Michael van der Veeke | DBA / IT Project Manager
Border Express Pty Ltd
306 Macauley St, South Albury NSW 2640
Ph: 02 6022 6046 | Fax: 02 6022 6050 | Mob: 0419 419 547
http://www.borderexpress.com.au

Celebrating 25 Years of Service

Multiple Award Winner:
2007 Family Business Australia - The NSW & ACT Family Business of the Year (2nd Generation)
2006 Australian Freight and Logistics Award – National Operator of the Year
2006 NSW Master Carrier of the Year
2006 ATA Training Excellence Award

NOTICE
Information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it.

 

 

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.484 / Virus Database: 269.13.1/982 - Release Date: 31/08/2007 5:21 PM

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net