Home > Archive > microsoft.public.sqlserver.server > November 2002 > I/O error while writing BCP data-file





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author I/O error while writing BCP data-file
joe

2002-11-11, 8:23 am

hi there,

i'm running snapshot replication on sql 2000 (SP2).
the snapshot agent fails with the following message:

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

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

i schedule the agent to run every hour. the thing is that it fails one
hour and then it succeeds the next.
i use all the default settings.

please help
cheers
Stefan

2002-11-11, 10:24 am

Did you check the repldata folder on distributor where the snapshots are
created ? Maybe you ran out of space on that disk.
Also, check the schedule for the replication cleanup job.

"joe" <joeb_nz@yahoo.com> wrote in message
news:a92a3ddc.0211110516.4e4f19ea@posting.google.com...
> hi there,
>
> i'm running snapshot replication on sql 2000 (SP2).
> the snapshot agent fails with the following message:
>
> "The process could not bulk copy out of table
> '[dbo].[syncobj_0x4145433644344643]'."
>
> "I/O error while writing BCP data-file
> (Source: ODBC SQL Server Driver (ODBC); Error number: 0)"
>
> i schedule the agent to run every hour. the thing is that it fails one
> hour and then it succeeds the next.
> i use all the default settings.
>
> please help
> cheers



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net