Synopsis
SQL Server 7 Admin: Managing Replication shows users how to create and administer database replication.

Audience
This course is for database administrators who want to learn how to administer SQL Server 7.0 or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Time
3 hours

Product Code: LA7C14
After completing SQL Server 7 Admin: Managing Replication the user should be able to:

Configure servers including distributors publishers and subscribers
Create publications
Set up and manage subscriptions

Using Replication
Understanding replication
Reviewing replication principles

Configuring Servers
Establishing a distributor
Creating publishers
Enabling subscribers

Creating Publications
Using snapshot publications
Using transactional publications
Using merge publications

Subscribing to Publications
Adding a pull subscription
Adding a push subscription
Adding an anonymous subscription

This course has the following features:

Exercises that allow users to practice in SQL Server 7.0
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
A glossary
A Skill Assessment

Courses on Relational Database Management Systems or equivalent experience
Courses on Windows NT administration or equivalent experience
Courses on Database Concepts or equivalent experience
Courses on SQL or equivalent experience
SQL Server 7 Admin: Security Strategy (LA7C01)
SQL Server 7 Admin: System Requirements (LA7C02)
SQL Server 7 Admin: Migration Planning (LA7C03)
SQL Server 7 Admin: Replication Plans (LA7C04)
SQL Server 7 Admin: Installing the Server (LA7C05)
SQL Server 7 Admin: Other Installations (LA7C06)
SQL Server 7 Admin: Configuring (LA7C07)
SQL Server 7 Admin: Security Management (LA7C08)
SQL Server 7 Admin: Managing Accounts (LA7C09)
SQL Server 7 Admin: Managing Permissions (LA7C10)
SQL Server 7 Admin: Database Management (LA7C11)
SQL Server 7 Admin: Loading Databases (LA7C12)
SQL Server 7 Admin: Backups and Restores (LA7C13)

Microsoft® is a registered trademark of Microsoft Corporation.