Best practices

After you have configured replication, it is important to understand how to administer a

replication topology. This topic provides basic best practice guidance in a number of areas with

links to more information for each area. In addition to following the best practice guidance

presented in this topic, consider reading through the frequently asked questions topic to

acquaint yourself with common questions and issues:

Frequently Asked Questions for

Replication Administrators.

It is useful to divide the best practice guidance into two areas:

The following information covers best practices that should be implemented for all

replication topologies:

Develop and test a backup and restore strategy.

Script the replication topology.

Create thresholds and alerts.

Monitor the replication topology.

Establish performance baselines and tune replication if necessary.

The following information covers best practices that should be considered, but might not

be required for your topology:

Validate data periodically.

Adjust agent parameters through profiles.

Adjust publication and distribution retention periods.

Understand how to change article and publication properties if application

requirements change.

Understand how to make schema changes if application requirements change.