SQL Server 7 Admin

Education Online - Career Education --- e-learning for Everyone.

Home

Training

Products

Specials

Tips

Resources

Login

FAQ's

Free Demo

Courses

Certification

Pricing

News

Contact Us

Synopsis
SQL Server 7 Admin: More Troubleshooting shows users how to resolve problems with database management and linked server issues.

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
4 hours

Product Code: LA7C19

After completing SQL Server 7 Admin: More Troubleshooting the user should be able to:

Diagnose and resolve problems with backup and restore operations

Diagnose and resolve replication problems

Diagnose and resolve job or alert failures

Diagnose and resolve distributed query problems

Troubleshooting Backups and Restores
Troubleshooting backups

Troubleshooting restores

After a database restore

Troubleshooting the SQL Server Agent
Checking the service startup account

Checking SQLAgentMail

Troubleshooting Jobs and Alerts
Checking jobs

Checking alerts

Troubleshooting Replication
Checking the replication configuration

Using the replication monitor

Linked Server Issues and Recovery Planning
Troubleshooting linked server issues

Planning for server repair and recovery

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

Activities that allow users to apply concepts in an interactive questioning environment

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)

SQL Server 7 Admin: Management Tasks (LA7C15)

SQL Server 7 Admin: Monitoring Events (LA7C16)

SQL Server 7 Admin: Watching & Optimizing (LA7C17)

SQL Server 7 Admin: Server Repair (LA7C18)

Microsoft® is a registered trademark of Microsoft Corporation.