Managing Data Between Servers and Databases


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005

Target Audience
Professionals pursuing a career as a Database Administrator

Prerequisites
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Expected Duration (hours)
2.5

Lesson Objectives

Managing Data Between Servers and Databases

  • identify considerations for managing change in the SQL Server 2005 environment, given a scenario.
  • determine the appropriate change control strategy for a given scenario.
  • recognize how to configure a linked server in a given scenario.
  • recognize how to query data on a linked server in a given scenario.
  • work with linked servers in a given scenario.
  • recognize how to monitor replication in a given scenario.
  • recognize how to modify replication configuration and resolve replication conflicts in a given scenario.
  • tune a replication configuration in a given scenario.

    • Course Number:
    238143_eng