Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The process could not bulk copy into table Expand / Collapse
Author
Message
Posted Tuesday, December 28, 2004 9:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 11:14 AM
Points: 56, Visits: 72

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

 

 

Post #152689
Posted Wednesday, December 29, 2004 3:58 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:48 PM
Points: 871, Visits: 281
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,



Post #152940
Posted Thursday, December 30, 2004 6:54 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 11:14 AM
Points: 56, Visits: 72

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

 

Thank

Post #153099
Posted Monday, January 3, 2005 4:36 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:48 PM
Points: 871, Visits: 281
Check to see that the Subscriber has enough disk space to perform the snapshot.


Kindest Regards,



Post #153363
Posted Tuesday, January 4, 2005 8:21 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:13 AM
Points: 4,432, Visits: 4,167

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



Markus Bohse
Post #153497
Posted Wednesday, January 5, 2005 8:21 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 536, Visits: 707

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.
Post #153760
Posted Thursday, January 6, 2005 1:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 10:07 AM
Points: 8, Visits: 11

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




Post #154108
Posted Thursday, December 18, 2008 3:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 1, 2009 5:35 AM
Points: 7, Visits: 28
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..


[b]Muhammad Rizwan Abid
System Analyst
mrizabid@hotmail.com
Post #621881
Posted Saturday, May 26, 2012 9:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:52 AM
Points: 10, Visits: 140
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
Post #1306979
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse