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 |
|
Mountain_Nerd
Starting Member
28 Posts |
 Posted - 2005-07-18 : 17:28:24
|
| My organization has outsourced our data maintenance to another organization and we are trying to establish transactional replication to our local server via an Internet VPN. We have been able to push the original snapshot and view the data; however, when the data is edited at the publisher, the replication breaks, reporting "The row was not found at the Subscriber when applying the replicated command."To test this problem, we set up another subscriber on-site at the publisher. This "local" subscriber receives the edits without issue, whereas the subscriber over the Internet VPN fails.Is there a transactional replication timeout that is being observed? If so, can I alter this setting? Perhaps the VPN is too slow to allow this to function properly. Any other ideas? I'm a bit perplexed. Our next step is to push a new snapshot, start a trace, and perform an edit. Hopefully the trace will provide more thorough information. Thanks in advance. |
|
|
|
|
|
Replication transaction timeout?