all groups > sql server replication > may 2006 >
You're in the

sql server replication

group:

transaction replication failure


transaction replication failure BigSam
5/5/2006 10:19:02 AM
sql server replication:
I'm trying to setup transaction replication between 2 servers. This is a
one-way replication: Server A to Server B, not Server B to Server A.
My snapshot publication keeps failing & I cannot determine why. I added
commands to the agent so that it would create an output file, possibly with
more or better information, but now I'm lost even more. Below is a portion of
the output file that should explain the trouble I'm having:

SourceTypeId = 5
SourceName = Publication
ErrorCode = 11
ErrorText = General network error. Check your network documentation.
The process could not bulk copy out of table
'[dbo].[syncobj_0x3531313845304531]'.
Repl Agent Status: 5
Disconnecting from Publisher 'Publication'
The agent failed with a 'Retry' status. Try to run the agent at a later time.

I've tried running the snapshot numerous times with the same results.
It appears that tables with 0 records complete successfully, but if any
table has more than 0 entries, this error is generated.
The Event Log (Application) reports instances of 'The process could not bulk
copy out of table', but nothing else.
I have setup a publication for the same database at another server, which
works, so I know it can be done.
All of the servers are running SQL 2k + SP4. Servers are running W2k, W2k
SBS, & W2k3.

Thanks,

Re: transaction replication failure Paul Ibison
5/7/2006 7:49:26 PM
Please can you check if there is a disk problem - eg is the disk full?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Re: transaction replication failure BigSam
5/8/2006 6:05:02 AM


[quoted text, click to view]
Re: transaction replication failure Paul Ibison
5/8/2006 2:37:16 PM
Can you successfully run "select * from syncobj_0x3531313845304531" (to rule
out blocking)?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


Re: transaction replication failure BigSam
5/9/2006 6:18:01 AM
Yes I was able to query the table from both servers. There were 0 rows
returned.

[quoted text, click to view]
AddThis Social Bookmark Button