Exam Essentials
Know how to implement and manage a linked server solution. Be familiar with when to use and how to implement a linked server strategy.
Know how to design a replication strategy. Understand the replication process. Be familiar with the types of replication and where each type could be applied. Understand the roles of the agents in the replication process.
Know how to design a maintenance plan to monitor health, latency, and failures. You need to know how to use predefined alerts and design alerts. You also need to be able to apply Replication Monitor to maintain and modify your replication topology.
Know how to verify replication. Be able to verify latency with tracer tokens. You need to know how to validate replicated data.
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.
