As with all IT efforts, proper planning is the key to successful implementation. Factors to consider when planning a replication strategy include the type of data to be published, the subscribers to the data, and the location of the subscribers. Publications can also contain more than one article. This flexibility provides a high degree of customization that enables DBAs to meet the needs of the subscriber communities. The DBA should select and partition data to minimize transmission times, bandwidth utilization, and storage requirements.
Optimization requires thorough analysis from the beginning.
These are some questions that must be answered before the DBA can deploy a successful replication strategy. SQL Server Eases Replication Setup SQL Server has taken much of the guesswork out of replication setup. Figures 6 through 10 depict some of the necessary steps for replication definition. The first step for the DBA is to identify the distributor. Since the publisher is dependent on the distributor, the DBA must identify a distribution server before establishing publication and subscription servers.