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
I'm using snapshot replications and It happens when the transactions are been replicated to the suscriber
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.
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.
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..