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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-20 : 09:23:41
|
| Ken writes "Publisher Database version: SQL Server 2000 - Standard Edition (SP2)Publisher Server OS: Windows 2000 Server (SP1)Subscribers Database version: MSDE 2000 (SP2)Subscribers OS: Win98, Win2kArchetecture:The system has one main publisher with up to 400 subscribers. In most cases the subscribers receive their view of the data via dial-up connection. Each of these subscribers can republish the data to another subset of subscribers.We are using merge replication with pull subscribers, dynamic filtering, and minimize network options set to true. We have also configured the snapshot for compression and FTP access. 28 of the 51 articles published have filters.The merge replication is triggered via the ActiveX components from a VB application.Currently, we are in testing with 10 system users.Problem 1:Our first problem is time outs between the Main Publisher and the subscribers. On occasion we have situations where the publisher believes the subscriber's merge agent is suspect because of no response within 20 minutes. I have set the inactivity threshold setting to 20 minutes. This issue comes up mostly with dial-up connections and/or computers with slower processors.Is there a way to eliminate or reduce the occurance of these time outs? Any suggestion or direction would be helpful.Problem 2:A situation has arisen when a conflict occurs on the Subscriber. The next time the Subscriber synchronizes, it deletes the data on the Publisher. It may be related to the filtering. However, it only occurs after the subscriber recieves a new facility assignment. A new facility is designed to trigger a new snapshot so the subscriber pulls down all the associated data. The Subscriber is required to make the decision to bring new snapshot down. How can we prevent the deletes?" |
|
|
|
|
|
Merge Replication