Sunday, February 19, 2012

Bulk Copy Failed During Snapshot

I'm trying to start a new publication. When the snapshot agent runs, it stops on a table with the error "Bulk Copy Failed". If I remove the table from the publication, it just moves the error to the next table it tries to copy. What could cause a bulk copy to fail during a snapshot?

Hello,

In order for any of us to provide further assistence, we will need:

1) The version of SQL Server that you are using

2) Additional information regarding the nature of the error. You can probably find this through the error details pane in the UI or you can select it directly from the MSrepl_errors table in the distribution database.

-Raymond

|||

Sorry about the lack of info. I've been working on this off and on for 2 months and have gone brain-dead trying to figure it out.

Version:

SQl Server 2000

on Windows Server 2003

Error message:

The process could not bulk copy out of table '[dbo].[xxxxx]'.

Error details:

I/O error while writing BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)

Thank you

(edited to correct versions)

|||

I am guessing this really is SQL2000 as the snapshot agent is using ODBC for performing the BCP operation. (There is no SQL2003)

The error "I/O error while writing BCP data-file" is typically caused by the lack of disk space on the snapshot drive. It may be a good idea to check if you have sufficient disk space on the snapshot drive.

Hope that helps,

-Raymond

No comments:

Post a Comment