[dba-SQLServer]Issues with Multiple Subscriptions

Mark Boyd MarkBoyd at McBeeAssociates.com
Thu Oct 30 14:50:44 CST 2003


I am in the process of creating 3 Push Subscriptions from 1
Distributor/Publisher.

Basically, I need all 4 SQL Servers to have the same data replicated
between each other.

 

Are there any known issues with setting up all 3 Replication Schedules
to run at the same times during the day?  I want to have the data
replicated every 15 minutes, between 5:00AM and 11:00PM.  Is there a
problem with each push having the same start time, or should I have each
start about 5 minutes after each other?

 

Are there any other issues I should consider?

 

TIA,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 



More information about the dba-SQLServer mailing list