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
 Import/Export (DTS) and Replication (2000)
 SQL Server Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-25 : 09:22:31
Ali writes "Hi,

I am working on Windows 2000 Server and Microsoft SQL Server 2000 Enterprise Edition.

I am using both Transactional Replication and Merge Replication at different levels in my project.
The Architecture of my SQL Replication implementation demands that the Production Server Database (the Publishing Server) be capable of serving hits even while Synchronization (through Replication) is running on the database. The Synchronization process is updating multiple subscribers. The Publishing Server is also configured as a Distributor.

My only worry is that whether the Publishing Server (which is also configured as a Distributor) and the Subscribing Server be able to serve hits even while synchronization is running between the two.

Hope to get an early reply....

thnx in advance
Best Regards,
Ali"

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-10-08 : 13:09:43
You can set replication up (I'm assuming push replication?) so that the push only occours when a certain amount of processor time is free.

-----------------------
SQL isn't just a hobby, It's an addiction
Go to Top of Page
   

- Advertisement -