SQL Server 2000 Replication

This course is included in our On-demand training solution.

Overview

To describe how to implement the SQL 2000 replication models

Target Audience

Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites

Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year’s experience administering SQL Server; at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration

105 min.

Course Objectives

SQL Server 2000 Replication

  • describe the fundamentals of data replication in SQL Server 2000.
  • configure and monitor SQL Server 2000 merge replication.
  • configure and manage SQL Server 2000 snapshot replication.
  • configure and manage transactional replication in SQL Server 2000.
  • describe how to configure a SQL Server 2000 server as a distributor.
  • configure a SQL Server 2000 server as a distributor.
  • configure a SQL Server 2000 server as a subscriber.
  • configure a SQL Server 2000 server as a subscriber.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?