Chapter 8

Designing a Strategy to Manage Replication

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Design a strategy to manage data across linked servers.
    • Set up and manage linked servers.
  • Design a strategy to manage replication.
    • Design alerts.
    • Design a maintenance plan to monitor health, latency, and failures.
    • Verify replication.
    • Design a plan to resolve replication conflicts.
    • Design a plan to modify agent profiles.
    • Tune replication configuration.

images Many organizations have their data stored in more than one location and often use several types of data stores. You can use several methods to ensure the data is available to meet users' ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial