March 11, 2010 at 9:07 am
Hello SQL Guru,
I setup a PUSH transaction replication with a local distributor and the initial snapshot was completed.
However, during the push from distributor to subscriber on those complete initial snapshot data.
My database replication encountered error of “The process could not bulk copy into table”.
I found Microsoft Tech Support links http://support.microsoft.com/kb/885460 that suggested to apply Microsoft SQL Server 2000 SP4.
The publisher server Microsoft SQL Server 2000 all ready has Microsoft SQL Server service pack 4.
The SQL Server 2000 version is 8.00.2039
Can anyone help and advice?
Thanks,
Edwin
March 11, 2010 at 9:45 am
Is it SQL 2000 to 2000? or other version? Did you check the collation is same on both publisher and subscriber database?
March 11, 2010 at 1:30 pm
Both the Publisher (Microsoft SQL Server 2000 SP4) and Subscriber (Microsoft SQL Server 2008 SP1)
have the same collation = SQL Latin1_General_CP1_CI_AS.
Can the collation issues cause replication error?
March 11, 2010 at 4:19 pm
Edwin-376531 (3/11/2010)
Both the Publisher (Microsoft SQL Server 2000 SP4) and Subscriber (Microsoft SQL Server 2008 SP1)have the same collation = SQL Latin1_General_CP1_CI_AS.
Can the collation issues cause replication error?
Yes, databases with different collation you cannot restore. What error are you seeing in replication monitor? can you apply snap shot again and see, some times if you delete or update more row than batch size limit it replication may break.
March 12, 2010 at 1:23 pm
Just curious, is your distributor agent using SQL Server Authentication or Windows Authentication and does the corresponding login on the subscriber server/database have adequate permissions.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply