Microsoft SQL Server 7.0: System Administration - Part 3

Course Code NGE72472

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

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.

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.

Prerequisites

(Currently no course prerequisite information)

Objective

• 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.

Topics Include

Unit 1: Backup Concepts

• 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

• 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

• 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.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media