The process could not bulk copy into table

Question

The process could not bulk copy into table

er sql

SSC Eights!

Points: 943
More actions
December 28, 2004 at 9:55 am

#361798

Hi, I'm working with replication and I publishing some databases from server A to server B, in replication monitor from mi server A i saw a message in two publications:
The process could not bulk copy into table XXXXX.
How can I fix the error?.

Thanks a lot
Sincerely
ER_SQL

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

TriggerMe SSChampion Points: 11752 More actions · Answer 1

What Replication model are you using?

Does this error occur when the initial Snapshot takes place or when the transactions are been replicated to the Subscriber?

Kindest Regards,

er sql SSC Eights! Points: 943 More actions · Answer 2

I'm using snapshot replications and It happens when the transactions are been replicated to the suscriber

Thank

TriggerMe SSChampion Points: 11752 More actions · Answer 3

Check to see that the Subscriber has enough disk space to perform the snapshot.

Kindest Regards,

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 4

How large is your DB. What kind of connection lies between the two servers ?

With larger tables over slower connections very often the reason for this message is a timeout. You can avoid this error by changing the snapshot agent profile settings.

M

[font="Verdana"]Markus Bohse[/font]

Paul Williams SSCommitted Points: 1910 More actions · Answer 5

This error is a fairly common error in replication and can be caused by a no. of issues. Usually, it is because the schema in the publisher does not match that of the subscriber.

To determine the exact cause, you need to increase the verbose history level of the output and create an output file when the snapshot or distribution agent runs.

Analysing this error file will then give more of an indication as to the exact cuase of the problem.

Paul R Williams.

amichals SSC Enthusiast Points: 188 More actions · Answer 6

Are you merge replicating a table that is being bulk copied into, such as a DTS for example?

If so the following link may help..

http://support.microsoft.com/default.aspx?scid=kb;en-us;275680

mrizabid Old Hand Points: 369 More actions · Answer 7

The process could not bulk copy into table '"xxxx"'

i m also facing this problem,

kindly guide me which agent profile is better and how can i do?

i set Transactional replication..

Muhammad Rizwan Abid
System Analyst
mrizabid@hotmail.com

davidsatz Mr or Mrs. 500 Points: 519 More actions · Answer 8

thank you - the developer add columns in the publishing database to the end of the table

but put them in the middle in the subscriber db