March 9, 2005 at 8:22 am
We are using SQL Server 2000 in a clustered environment. I have transactional replication with the log reader always failing with the following error:
The process could not execute 'sp_replcmds' on 'SQLProblem2\SQLProblem2'
The error goes on to say it retried the process the requested number of times (10) and that it failed.
So I set it to reinitialize and then started the snapshot agent. The snapshot agent gives me the following error after trying for a while (and seeming to be doing just fine):
The process could not bulk copy out of table '[dbo].[syncobj_0x4437424242343241]'.
Has anyone seen this before and can you give me any advice on how to get replication working again? We have identical replication between other servers which is working fine.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
March 10, 2005 at 12:19 am
Quickest method may be to drop the publication and recreate it.
March 10, 2005 at 1:59 am
can you read agent histroy and send the actual error; i have seen some problems like this can help you but if first you give exact error
March 10, 2005 at 2:54 pm
You can try restarting the log reader agent. The transactions are probably piling up in the distribution database so you do not need to do a reinit. To keep it from happening as often you can increase the time out value for the log reader agent. In enterprise manager open the log reader agent, go to steps, the second step should be “Run.” Edit it and add:
-QueryTimeOut 1000
to the configuration string.
When I was having this problem is was because of blocking on the subscriber database slowing the speed of inserts from the distributor.
March 10, 2005 at 2:57 pm
Sorry, I should have said piling up in the log, not the distribution database.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply