McSe Exam Notes: SQL Server 7 Administration : Exam 70-028

by Sawtell, Rick; Mortensen, Lance; Jorden, Joseph L.

• ISBN13: 9780782124774
• ISBN10: 0782124771
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: John Wiley & Sons Inc

Summary

MCSE Exam Notes: SQL Server 7 Administration provides the fastest and most effective way to make sure you're ready for Exam 70-028, Administering SQL Server 7.
The unique, innovative Exam Notes approach helps you gain and retain the knowledge you need, objective by objective.

Author Biography

Joseph L. Jorden is currently an instructor for Unitex Inc. in Fremont, CA.

Table of Contents

Introduction	p. viii
Planning	p. 1
Develop a security strategy.	p. 4
Develop a SQL Server capacity plan.	p. 16
Develop a data availability solution.	p. 26
Develop a migration plan.	p. 35
Develop a replication strategy.	p. 39
Installation and Configuration	p. 57
Install SQL Server 7.	p. 59
Configure SQL Server.	p. 73
Implement full-text searching.	p. 80
Configuring and Managing Security	p. 87
Assign SQL Server access through Windows NT accounts, SQL Server logins, and built-in administrator logins.	p. 89
Assign database access to Windows NT accounts, SQL Server logins, the guest user account, and the dbo user account.	p. 96
Create and assign SQL Server roles. Server roles include fixed server, fixed database, public, user-defined database, and application.	p. 101
Grant to database users and roles the appropriate permissions on database objects and statements.	p. 111
Audit server and database activity.	p. 118
Managing and Maintaining Data	p. 125
Create and manage databases.	p. 128
Load data by using various methods. Methods include the INSERT statement, the SELECT INTO statement, the bcp utility, Data Transformation Services (DTS), and the BULK INSERT statement.	p. 148
Back up system databases and user databases by performing a full database backup, a transaction log backup, a differential database backup, and a filegroup backup.	p. 174
Restore system databases and user databases from a full database backup, a transaction log backup, a differential database backup, and a filegroup backup.	p. 188
Manage replication.	p. 200
Automate administrative tasks.	p. 238
Enable access to remote data.	p. 258
Monitoring and Optimization	p. 263
Monitor SQL Server performance.	p. 265
Tune and optimize SQL Server.	p. 292
Limit resources used by queries.	p. 299
Troubleshooting	p. 303
Diagnose and resolve problems in upgrading from SQL Server 6.x.	p. 305
Diagnose and resolve problems in backup and restore operations.	p. 309
Diagnose and resolve replication problems.	p. 312
Diagnose and resolve job or alert failures.	p. 318
Diagnose and resolve distributed query problems.	p. 321
Diagnose and resolve client connectivity problems.	p. 323
Diagnose and resolve problems in accessing SQL Server, databases, and database objects.	p. 329
Index	p. 334
Table of Contents provided by Syndetics. All Rights Reserved.