Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
erenshaw
Starting Member
2 Posts |
 Posted - 2007-08-22 : 11:22:11
|
| SQL Server 2000 SP4I am trying to run the initial snapshot on a db that is approximately 21GB. Server1 is the publisher and distributor. If I select a portion of the tables that I need replicated, the snapshot is successful. If I select all of the tables that I need, the initial snapshot fails with:The process could not bulk copy out of table dbo.syncobj_0x4231464445423943General Network error. Check your network documentation.I am confused as to the nature of this error because the initial snapshot is being created on a local drive with plenty of space. Why would a netwok error be produced if nothing is technically being transferred over the network?Please help, I have spent a week on this already with no success.Thanks in advance...Em |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 22:32:10
|
| Subscriber is on same server? If not, distributor has to ship 21gb data to subscriber via network. |
 |
|
|
erenshaw
Starting Member
2 Posts |
Posted - 2007-08-24 : 15:21:25
|
| I see. I was confused because the output log for the snapshot replication agent didn't list any mention of transferring data to the second server. I thought the snapshot was created first and then transferred to the subscriber. This is not the case? No snapshot is listed in the local folder so I think it is not being created at all.Em |
|
|
|
|
|
|
General Network Error on Initial Snapshot