SQL Server 7 Admin: Backups and Restores

Education Online - Career Education --- e-learning for Everyone.

Home

Training

Products

Specials

Tips

Resources

Login

FAQ's

Free Demo

Courses

Certification

Pricing

News

Contact Us

Synopsis
SQL Server 7 Admin: Backups and Restores shows users how to back up and restore data on SQL 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: LA7C13

After completing SQL Server 7 Admin: Backups and Restores the user should be able to:

Back up system databases and user databases

Restore system databases and user databases

Introduction to Backups
Backing up your databases

Working with backup devices

Database Backups
Working with database backups

Creating a database backup

Using the BACKUP DATABASE statement

Restoring a database backup

Using the RESTORE DATABASE statement

Using a restore to move a database

Differential Backups
Working with differential backups

Creating a differential backup

Restoring a differential backup

Transaction Log Backups
Working with transaction log backups

Creating a transaction log backup

Using the BACKUP Log statement

Restoring transaction log backups

Using the RESTORE Log statement

Filegroup Backups
Creating a file or filegroup backup

Restoring a file or filegroup backup

Backing Up System Databases
The master database

Other system databases

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)

Microsoft® is a registered trademark of Microsoft Corporation.