SQL Server Performance Forum – Threads Archive

Merge replication is not working properly

Hi all, We have SQL SERVER 2000 replication setup. Service pack 4 is installed on all Publishers and subscriber.
Our Organization setup is as follows. We have one Head Office, 10 Range offices, 29 Circle Offices and 5 Check Gates.
WE are using merger replication. Head Office is the main publisher.
Check Gates are the subscribers to Head Office.
Range Offices are the subscriber to the Head Office also they are Publisher to Circle Office.
Circle offices are the Subscribers to range office. In turn our Hierarchy looks as Check Gates(Subsriber) ——> Head Office(Main Publisher)———-> Range Office(Subsriber to HO & PubLisher to Circles) ——–> Circle Office (Subscriber TO Ranges)
We are using most of the default settings while setting up the replication. My problem is that Data entered at Check Gates is replicated to the Head office & Range Office only. It is not going to the circle office.
Is there any special setting required to replicate data up to fourth level. Can anybody help me in solving this problem? Anuj Sharma

It is not going to the circle office
Have you checked for any network issues between these 2 locations?
Check the current activity on the SQL Server when it is running. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi, may suggest to refer below links in this regards : http://support.microsoft.com/?id=315521 www.mssqlcity.com/Articles/ Replic/troubleshooting_replication.htm Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Problem is not solved. Can I use DTS in place of replication in this senario. If yes, Pls tell me how to Setup DTS. Anuj Sharma

Have you checke what has been referred above?
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

You cannot use DTS if there are records that need to be updated.
E.g. if one table in one location is 1 and a user just update the record in the table in the other location as 2 Replication will update the table in that location from 1 to 2. If DTS is used, the record will be appended instead. This will messed up the databases in different locations.

]]>