Microsoft SQL Server 7.0: System Administration- Part 3 CBT Training CD

Rating:
Summary: Microsoft SQL Server 7.0: System Administration- Part 3 CBT
Review: Course Overview
This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.

Learn To

Identify the concepts, interfaces and fixed roles involved in performing backups.
Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as a system administrator.
Restore damaged or incomplete databases.

Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first two courses in this series.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Backup Concepts 2 - 3 hours

Match the backup type with its features.
Identify the fixed roles with permission to perform backups.
Identify the circumstances that make system database backup necessary.
Identify the situations in which Transact-SQL must be used to perform a function.
Identify the available media for database backup.
Identify activities that cannot be performed while a backup operation is in process.
Match the three primary backup devices with their features.
Perform the steps necessary to create a temporary backup file.
Perform the steps necessary to create permanent backup files.
Perform the steps necessary to add multiple files to a backup statement.
Match six of the advanced options available in the Transact-SQL BACKUP statement with their functions.
Associate the six tape backup options with their functions.

Unit 2: Performing Backups 2 - 3 hours

Match the proper full backup frequency with its scenario.
Perform the steps necessary to create a full database backup.
Identify the scenarios for which differential backup would be appropriate.
Perform the steps necessary to create a differential database backup.
Identify the features of transaction log backups.
Perform the steps necessary to back up the transaction log.
Associate the options for clearing the transaction log with their functions.
Identify situations in which filegroup backup is preferable to full database backup.
Identify situations in which multiple files must be backed up as a unit.
Perform the steps necessary to create a filegroup backup.

Unit 3: Restoring Databases 2 hours

Identify the functions performed by SQL Server 7.0 when the system is restarted.
Match the verification options with their functions.
Identify the steps used to prepare the database for recovery.
Associate restore options with their functions.
Identify the units that must be restored to reinstate the system database.
Identify cases in which the user databases must be attached to the master database.
Perform the steps necessary for restoring a database from a full backup set.
Perform the steps necessary to restore a database from a differential backup.
Perform the steps necessary to recover a database from transaction log backups.
Perform the steps necessary to restore a database from transaction log backups.
Perform the steps necessary to recover a database file from a filegroup backup.
Perform the steps necessary to restore a database filegroup from a filegroup backup.
Identify the uses of a standby server.
Sequence the steps necessary for entering the correct backup data in a standby server.
Identify the functions of the STANDBY option.
Sequence the steps for replacing a production server.
Sequence the steps required for restoring a database that has no transaction log.
Sequence the steps in a database restoration solution.
Sequence the steps in a recovery strategy for a differential backup.
Select a step in the recovery strategy for a filegroup backup.