SQL Server 7 Admin

Synopsis
SQL Server 7 Admin: Server Repair shows users how to troubleshoot problems with installation upgrading and access to 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
4 hours

Product Code: LA7C18

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

Diagnose and resolve problems with upgrading from SQL Server 6.x

Use the Client Configuration utility to diagnose and resolve client connectivity problems

Diagnose and resolve problems regarding access to SQL Server databases and database objects

Overview of Troubleshooting
Preparing to troubleshoot

SQL Server startup parameters

SQL Server command-line utilities

Solving Installation Problems
Basic installation checklist

Planning for installation

Advanced installation problems

Solving Upgrading Problems
Upgrade overview

Output from the upgrade process

More About Upgrading Problems
Double-checking the upgrade prerequisites

Special upgrade considerations

Compatibility issues

Troubleshooting Server Access Problems
Network connectivity

NT Authentication

SQL Server Authentication

Troubleshooting SQL Server Permissions
Accessing databases

Shortcut to find a user's groups

Object access permissions

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)

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: More Troubleshooting (LA7C19)

Microsoft® is a registered trademark of Microsoft Corporation.

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.