MCSE Readiness Review, Exam 70-028 : Administering Microsoft SQL Server 7.0

by Jill Spealman

• ISBN13: 9780735606722
• ISBN10: 0735606722
• Format: Paperback
• Copyright: 1999-09-01
• Publisher: Microsoft Pr

Summary

Provides the information you need to prepare for the MCSE Readiness Review Exam 70-028: Administer- ing Microsoft SQL Server 7.0. Provides a focused, way to identify the information you need to know to pass the MCP exams. Softcover. CD-ROM included. DLC: Electronic data processing personnel-- Certification.

Table of Contents

Welcome to Administering Microsoft SQL Server 7.0	vii
Before You Begin	viii
Using the MCSE Readiness Review	x
Exam Objectives Summary	xvi
Getting More Help	xix
Planning	1	(68)
Develop a security strategy	5	(12)
Develope a SQL Server capacity plan	17	(14)
Develop a data availability solution	31	(14)
Develop a migration plan	45	(14)
Develop a replication strategy	59	(10)
Installation and Configuration	69	(34)
Install SQL Server 7.0	71	(12)
Configure SQL Server	83	(12)
Implement full-text searching	95	(8)
Configuring and Managing Security	103	(58)
Assign SQL Server access to Windows NT accounts, SQL Server login accounts, and built-in administrator accounts	107	(10)
Assign database access to Windows NT accounts, SQL Server login accounts, the guest user account, and the dbo user account	117	(10)
Create and assign SQL Server roles	127	(12)
Grant to database users and roles the appropriate permissions on database objects and statements	139	(12)
Audit server and database activity	151	(10)
Managing and Maintaining Data	161	(92)
Create and manage databases	165	(14)
Load data using various methods	179	(10)
back up system and user databases by performing a complete database backup, a transaction log backup, a differential database backup, and a filegroup backup	189	(14)
Restore system and user databases from a complete database backup, a transaction log backup, a differential database backup, and a filegroup backup	203	(12)
Manage replication	215	(12)
Automate administrative tasks	227	(12)
Enable access to remote data	239	(14)
Monitoring and Optimization	253	(44)
Monitor SQL Server performance	255	(14)
Tune and optimize SQL Server	269	(16)
Limit resources used by queries	285	(12)
Troubleshooting	297	(78)
Diagnose and resolve problems in upgrading from SQL Server 6.x	299	(10)
Diagnose and resolve problems in backup and restore operations	309	(12)
Diagnose and resolve replication problems	321	(12)
Diagnose and resolve job or alert failures	333	(10)
Diagnose and resolve distributed query problems	343	(12)
Diagnose and resolve client connectivity problems	355	(10)
Diagnose and resolve problems in accessing SQL Server, databases, and database objects	365	(10)
Appendix: The Microsoft Certified Professional Program	375	(12)
Preparing for an MCP Exam	375	(2)
Taking an Exam	377	(2)
Getting Your Exam Results	379	(1)
About the Exams	379	(1)
Overview of the MCP Program	380	(5)
References	385	(2)
Glossary	387	(16)
Index	403