After completing SQL Server 7 Admin: System Requirements the user should be able to:

	Plan the physical placement of files including data files and log files
	Plan the use of filegroups
	Plan for growth over time
	Plan the physical hardware system
	Assess the server's communication requirements
	Choose the appropriate backup and restore strategies
	Assess whether to use a standby server
	Assess whether to use clustering

Data File Placement and Space

	Developing a SQL Server capacity plan
	Estimating storage requirements

Capacity Planning

	Performance versus fault tolerance
	Using software-based RAID solutions
	Using hardware-based RAID solutions
	Making a choice
	Implementing fault tolerance

Communication and Backup Strategies

	Communication requirements
	Planning communication requirements
	Developing a data availability solution
	Restoring backups

Data Availability

	Benefiting from a standby server
	Clustering Microsoft SQL Server 7.0
	Clustering fundamentals

This course has the following features:

	Exercises that allow users to practice the skills needed to identify system requirements for SQL Server 7.0
	A file containing the text of the exercises
	Activities that allow users to apply concepts in an interactive questioning environment
	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)

Microsoft® is a registered trademark of Microsoft Corporation.