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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL SERVER 2000 - REPLICATION

Author  Topic  dsvmills Starting Member 1 Post Posted - 2010-05-25 : 03:10:25 Dear sir, We have configured SQL SERVER 2000 with transactional replications in two different location. For eg. Madurai & Chennai. We have connected both end by 512 MB Dedicated Leased line. In Madurai location server name is MDUSERVER and Chennai Location server name MSSERVER. We have configured MDUSERVER as main server and it act as a PUBLISHER, and MSSERVER as SUBSCRIBER. All data are entered in the CHENNAI will store in MADURAI SERVER only . My Database name is SPDATA. Both are working fine. Now we are going to configure another SERVER in TRICHY and we got leased line from TRICHY to MADURAI office end. How can I merge TRICHY SERVER with MDUSERVER and MSSERVER. 1) Shall I configure the TRICHY SERVER as like CHENNAI server 2) Shall I use SPDATA for TRICHY server otherwise I have to create another DATABASE for TRICHY. (ie. Data storage location is MADURAI) 3) I want to replicate data to CHENNAI & TRICHY server. Kindly provide best idea for me. RAJASEKAR