September 8, 2003 at 8:32 am
I'm running trans repl on SQL2K sp2, and sometimes I get an error when the nightly job runs. I works fine about half the time. I pipe to an outfile and find the following:
"The process could not bulk copy out of table '[dbo].[syncobj_0x373231...]
Repl agent status:6
Disconnecting from publisher 'SQLDB-01'
I see which table "syncobj.0x373231... " refers to, but not the cause of the problem. I'm assuming there's some lock problem on the table with another application ? Any ideas ??
By the way, I'm doing
-Output :\Log\Prd_TransRepl_Agent.txt -Outputverboselevel 3
What's the switch to replace the text each time ?
September 8, 2003 at 1:00 pm
Lock seems likely, easy enough to test - just open a table in EM, holds a lock. Why are you running the snapshot every night?
Andy
September 8, 2003 at 1:27 pm
I'm not meaning to run the entire snapshot every night ..... just the transactions .... hmmmmm .....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply