SQL Server 6.5: System Management

Synopsis
SQL Server 6.5: System Management provides instruction on database maintenance through transaction logs and recovery as well as backup and restore. It also covers remote and distributed management options of Microsoft ® SQL Server TM 6.5.

Audience
This course is for anyone preparing for the MCSE Exam 70-026 System Administration for Microsoft ® SQL Server TM 6.5 or a system administrator who needs to manage recovery from transaction logs, restored data from backups, or remote systems.

Time
4 hours

Product Code: SQSC05

After completing SQL Server 6.5: System Management, the user should be able to:

Identify how automatic recovery works

Perform a database dump and load a database dump

Perform a striped backup

Configure and manage server in the enterprise

Set up alerts and schedule tasks

Database Logging and Recovery

Transactions and Transaction Logging

Checkpoints

Recovery

SQL Server Database Backup and Restoration

Types of Backups

Backup and Restore Commands

Developing Your Backup-and-Restore Plan

Remote Server Management

Adding and Removing Servers

Adding and Removing Remote Logins

The MS SQL Server Distributed Management Framework

SQL Executive, Exception Processing, and Task Scheduling

Configuring Tasks, Operators, and Alerts

This course is distributed with

Exercises, with sample files, that allow users to practice in SQL Server 6.5

A file containing the text of the exercises

Simulations that allow users to practice course skills, even if they don't have access to the SQL Server 6.5 product

A SQL Server 6.5 glossary