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 - 2005-06-27 : 08:31:08
|
| Shamshad writes "Hi,I have been working as a Developer and mainting SQL Server 2000 since last 4 years. we have 9 difference locations and we have one corporate location. All data resides on main office. corporate site has database setup with Merge replication. For back up we have 3 sites that are configured to replicate whole database, 6 remote locations has horizontal merge replication setup. since last few months the replication with filtered artilces are creating problem and when we connect servers to start repliction the Headoffice main server CPU usages utelized 100% till we stop it. Mostly it shows following message."Failed to enumerate changes in the filtered article."incase you have NE further question let me.Server configuration:Pentium - III2Gig RamMicrosoft windows 2000 sp4SQL Server SP 3The database size is 1.5 GB,All remote locations has following configuration.PIV - 512 Ram - 25 GB HDD space" |
|
|
|
|
|
SQL Server Merge replication with horizontal filtering