Administering Replication

This chapter contains information on administering replication topologies. It is recommended that you read the best practices topic first, and then follow the links from that topic to more detailed information in this chapter and other chapters.

Topic Description

Best Practices for Replication Administration

Describes a variety of best practices, including information about backup and restore, monitoring, performance, and maintenance tasks.

Frequently Asked Questions for Replication Administrators

Addresses a wide variety of questions related to administrative tasks and how replication functions.

Maintaining Publications

Describes how to add and drop articles from publications and provides a list of property changes that require reinitialization or the generation of a new snapshot.

Monitoring Replication

Describes monitoring replication status and performance with Microsoft SQL Server Replication Monitor, and monitoring replication performance with System Monitor.

Administering Replication Agents

Provides information on replication agents, agent profiles, and using alerts.

Backing Up and Restoring Replicated Databases

Details considerations for backing up and restoring replicated databases, with strategies for each type of replication.

Enhancing Replication Performance

Describes general performance improvements for replication and specific guidance for each type of replication.

Validating Replicated Data

Provides information on validating data at Subscribers to determine whether the data matches the data at the Publisher.

Upgrading Replicated Databases

Describes how to upgrade instances of SQL Server in a replication topology.

See Also

Other Resources

Configuring and Maintaining Replication

Help and Information

Getting SQL Server 2005 Assistance