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.