Synopsis
SQL Server 7 Admin: Management Tasks shows users how to manage a variety of administrative tasks including server jobs events alerts linked servers and remote servers.

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: LA7C15
After completing SQL Server 7 Admin: Management Tasks the user should be able to:

Automate administrative tasks
Configure SQL Server Agent
Define jobs and create multiserver jobs
Define operators and alerts
Set up SQLAgentMail for job notification and alerts
Set up linked servers
Set up security for linked databases

Configuring the SQL Server Agent
Configuring the startup account
Changing the connection method
Configuring SQL Server Agent mail

Implementing Jobs
Creating jobs
Changing job properties
Creating job categories

Multiserver Jobs
Administrating multiserver environments
Creating an MSX and a TSX
Creating multiserver jobs
Scripting jobs

Managing Server Events
Defining operators
Defining alerts
Forwarding events
Copying operators/alerts to other servers

Linked Servers
Accessing Data
Setting up a linked server
Managing security

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)
SQL Server 7 Admin: Managing Replication (LA7C14)

Microsoft® is a registered trademark of Microsoft Corporation.

 

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information