Training
Provided by 123-CBT Computer Based Training
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.
Content Emphasis
Skills-Based
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.
Total Learning Time
6 - 8 Hour(s)
Unit 1: Backup Concepts
Duration: 2 - 3 Hour(s)
- 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
Duration: 2 - 3 Hour(s)
- 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
Duration: 2 Hour(s)
- 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
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This program may be available on CD |  | Contact 123-CBT Computer Based Training for more information |
|
| Training Presented in: | English |
|
Related Keywords:
microsoft
sql
server
7.0
system
administration
part
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More Microsoft SQL Server 7 0 Training from 123-CBT Computer Based Training
Click here for more information or to take this course
| 
