Microsoft SQL Server 7.0系统管理（英文）

About This Book

Intended Audience

Prerequistes

Reference Materials

About the CD-ROMs

Features of This Book

Chapter and Appendix Overview

Finding the Best Starting Point for You

Getting Started

The Microsoft Certified Professional Program

Technical Support

Chapter 1 Wverview of SQL Server

About This Chaper

Before You Begin

Lesson 1: What Is SQL Server

Client/Server Architecture

SQL Server Platforms

SQL Server Integration with Windows NT

SQL Server Integration with Microsoft BackOffice

Lesson Summary

Lesson 2: SQL Server Components

SQL Server Services

SQL Server Client Software

SQL Server Help and SQL Server Books Online

Practice: Using SQL Server Books Online

Lesson Summary

Lesson 3: Wverview of SQL Server Architecture

Communication Architecture

Data Access Architecture

Administrative Architecture

Application Architecture

Lesson Summary

Lesson 4: Overview of SQL Server Security

Login Authentication

Permission Validation

Database user Accounts and Roles

Lesson Summary

Review

Chapter 2 Installation

About This Chaper

Before You Begin

Lesson 1: Preparing to Install SQL Server

Hardware and Software Requirements

SQL Server Installation Options

Lesson Summary

Lesson 2: Running SQL Server

Setup and Testing the installation

Types of SQL Server installation

Testing the Installation

practice: Using a Graphical utility to Connect to SQL Server

Lesson Summary

Lesson 3: Performing an Unattended Installation

Using the Sample Unattended Inatallation

Generating or Creating a Custom Setup Initialization Script File

Invoking Setup

Using Microsoft Systems Management Server

Lesson Summary

Review

Chapter 3 Upgrading to SQL Server 7.0

About This Chaper

Before You Begin

Lesson 1: Introduxtion to Upgrading SQL Server

The Upgrade Process

Upgrade Considerations

Upgrade Summary

Lesson 2: Using the SQL Server Upgrade Wizard

Choosing an Upgrade method

Selecting Upgrade Options

Running the Upgrade

Lesson Summary

Lesson 3: After Using the SQL Server Upgrade Wizard

Removing SQL Server 6.5

Troubleshooting the Upgrade

Specifying Compatibility Levels

Backward Compatibility Details

Lesson Summary

Review

Chapter 4 System Configuration and Architecture

About This Chaper

Before You Begin

Lesson 1: Preparing to Use SQL Server

Configuring SQL Server Enterprise Manager

Client Installation

Configuring SQL Server

Troubleshootin SQL Server Installation

Lesson Summary

Lesson 2: Working with SQL Server

SQL Server Activities

Client/Server Tools

Lesson Summary

Lesson 3: SQL Server Databases

Types of Databases

Database Objects

System Tables

Lesson Summary

Review

Chapter 5 Database Files

About This Chaper

Before You Begin

Lesson 1: Introduction to Databases

How Data Is Stored

SQL Server Database Files

how the Transaction Log Works

Lesson Summary

Lesson 2: Creating and Dropping Databases

Creating Databases

Dropping a Database

Lesson Summary

Lesson 3: Managing Databases

Database Options

Managing Data and Log File Growth

Lesson Summary

Lesson 4: Managing Databases on Multiple Disks

Leveraging Windows NT Server Fault Tolerance

Creating Filegroups

Performance Considerations

Lesson Summary

Lesson 5: Capacity Planning

Estimating the Minimum Size of a Database

Lesson Summary

Review

Chapter 6 Transferring Data

About This Chaper

Before You Begin

Lesson 1: Introduction to Transferring Data

Why Transfer Data

Why Transform Data

Tools for Transferring Data in SQL Server

Lesson Summary

Lesson 2: Introduction to Data Transformation Services

Overview of DTS

The DTS Process

DTS Tools

Lesson Summary

Lesson 3: Transforming Data with DTS

Restructuring and Mappign Data

Defining workflows

Executing and Scheduling a DTS Package

Lesson Summary

Lesson 4: Linked Servers

Introduction to Linked Servers

Adding Linked Servers

Security Considerations for Linked Servers

System Stored procedures for Working with Linked Servers

Executing a Distributed Query

Lesson Summary

Review

Chapter 7 Web Publishing and Full-Text Indexing

About This Chaper

Before You Begin

Lesson 1: Publishing Database Data to Web Pages

How Web Publishing Works

Specifying Web Page Characteristics

Using an HTML Template File

Managing Web Assistant Jobs

Lesson Summary

Lesson 2: Full-Text Indexing and Searching

Introduction to Full-Text Searching

Full-Text Search with SQL Server 7

Introduction to Creation Full-Text Indexes

Maintaining Full-Text Indexes

Setting Up Full-Text Search

getting Information About Full-Text Search

Writing Full-Text Queries

Lesson Sunnary

Review

Chapter 8 Backup and Restore Overview and Strategy

About This Chaper

Before You Begin

Lesson 1: Backup Overview

Preventing Data Loss

Using Backup and Restore for Other Purposes

SQL Server Backup

Performing and Storing Backups

The SQL Server Online Backup Process

When to Back Up Databases

Lesson Summary

Lesson 2: Backup Strategy

Planning a Backup Strategy

Performance Considerations

lesson Summary

review

Chapter 9 Backing Up Databases

About This Chaper

Before You Begin

Lesson 1: Backup Devices

Overview of Backup Devices

Creating Named Backup Devices

Creating Temporary Backup Devices

Using Multiple Backup Devices to Store Backups

Lesson Summary

Lesson 2: Performing Backups

Using the BACKUP Statement

Performing a Complete Database Backup

Performing a Transaction Log Backup

Clearing the Transaction Log

Performing a Differential Backup

Performing Data File or Filegroup Backups

Lesson Summary

Review

Chapter 10 Restoring Databases

About This Chaper

Before You Begin

Lesson 1: The SQL Server

Recovery and Restore Processes

Database Recovery

SQL Server Activities During the Restore Process

Lesson Summary

Lesson 2: The RESTORE Statement

Preparing to Restore a Database

Lesson Summary

Lesson 3: Performing a Database Restore

Restoring from a Complete Dababase Backup

Restoring from a Differential Backup

Restoring from a transaction Log Backup

Practice: Restoring a Database

Lesson Summary

Lesson 4: Using a Standby SQL Server

Setting Up a Standby SQL Server

Using the Standby SQL Server as a Read-Only Server

using the Standby SQL Server

to Troubleshoot Data Corruption

Replacing a Production Server with a Standby SQL Server

Restoring the production Server

Using Clustering

Lesson Summary

Review

Chapter 11 Logins, User Accounts, and User Roles

About This Chaper

Before You Begin

Lesson 1: Adding Login Accounts

Default Databases

Default Login Accounts

Granting a Windows NT ccount Access to SQL Server

Adding a SQL Server Login

Lesson Summary

Lesson 2: How Login Accounts

Are Authenticated When Users Connect

Authentication Processing

How SQL Server Processes

Logins That Windows NT Authenticates

How SQL Server Processes Login That It Authenticates

Choosing an Authentication Mode

Step in Implementing One of the Authentication Modes

Lesson Summary

Lesson 3: Granting Access to Databases

Granting Database Access to Logins

Assigning Logins to Roles

Lesson Summary

Review

Chapter 12 Permissions and Security Planning

About This Chaper

Before You Begin

Lesson 1: types of Permissions

The Three Types of Permissions

Lesson Summary

Lesson 2: Assigning Permissions to Users and Roles

permission States

Granting Permissions

Denying Permissions

Revoking Granted and Denied Permissions

When a Revoke Is Not a Revoke

Lesson Summary

Lesson 3: Planning Security

Goals in Creating a Security Plan

Determine the Use of Default Logins

Determine public Role Permissions

Determine the function of the guest User Account

Lesson Summary

Lesson 4: Managing Application Security

Managing Security with Views and Stored Procedures

Managing Security with Application Roles

Managing Application Role Permissions

Activating Application Roles

Lesson Summary

Review

Chapter 13 Automating Adminstrative Tasks

About This Chaper

Before You Begin

Lesson 1: Introduction to SQL Server Automated Administration

Reasons to Automate

Components of SQL Server Automated Administration

Processing Jobs and Alerts

Preparing to Automate

Practice: Configuring Mail Profiles

Lesson Summary

Lesson 2: Automating Routine Maintenance Tasks

Creating Operators to Notify

Creating Jobs

Defining Job Steps

Determining Action Flow Logic for Each Job Step

Scheduling Jobs

Multiple Schedules

Reviewing and Configuring job History

practice: Configuring SQL Mail

Lesson Summary

Lesson 3: Creating Alerts

Using Alerts to Respond to Potential Problems

Creating Alerts to Respond to SQL Server Errors

Configuring Event Forwarding

Reaponding to Performance Condition Alerts

Practice: Creating a Performance Condition Alert

Assigning a Fail-Safe Operator

Lesson Summary

Lesson 4: Troubleshooting SQL Server Automated Administration

Automated Administration Troubleshooting Checklist

troubleshooting Alerts

Lesson Summary

Lesson 5: Establishing a Multiserver Environment

Grouping Multiple Servers

Automating Jobs in a Multiserver Environment

Lesson Summary

Review

Chapter 14 Monitoring and Maintaining SQL Server

About This Chaper

Before You Begin

Lesson 1: Why Monitor SQL Server

Reasons to Monitor SQL Server

Factors That Affcet Performance

Detecting Performance Bottlenecks

Configuring a Query Governor

Lesson Summary

Lesson 2: Tools for monitoring SQL Server

Common Monitoring Tasks

Using the Windows NT Event Viewer

Using SQL Server Performance Monitor

Practice: Monitoring SQL Server

Activity with SQL Server Performance Monitor

Using Transact-SQL to Monitor SQL Server

Using SQL Server Profiler

Using SQL Server Query Analyzer

Using Current Activity in SQL Server Enterprise Manager

practice: Managing Locks

Lesson Summary

Lesson 3: Maintaining SQL Server

Developing a Database Maintenance Plan

Automating the Database Maintenance Plan Tasks

Lesson Summary

Review

Chapter 15 Introducing Repllcation

About This Chaper

Before You Begin

Lesson 1: introduction to Distributed Data

The Need for Distributing Data

Considerations for Distributing Data

Methods of Distributing Data with SQL Server

Lesson Summary

Lesson 2: introduction to SQL Server Replication

The Publisher-Subscriber Metaphor

Publications and Articles

Filtering Data

Subscriptions

Lesson Summary

Lesson 3: SQL Server Replication Types

Snapshot Replication

The Snapshot Replication Process

Transactional Replication

The Transactional Replication Process

The Immediate Updating Subscribers Option

Merge Replication

SQL Server Replication Agents

Lesson Summary

Lesson 4: Physical Replication Models

Overview of the Replication Models

Combining Replication Models and Types

Lesson Summary

Review

Chapter 16 planning and Setting Up Replication

About This Chaper

Before You Begin

Lesson 1: Planning Replication

Design Considerations

Determining a Replication Solution

Data Definition Issues

Configuring Network Security Access

Lesson Summary

Lesson 2: Preparing the Servers

Setting Up a Distributor

Configuring a Distributor

Setting Up a Publisher

Setting Up a Subscriber

Agent Profiles

Practice: Replication Exercises

Lesson Summary

Lesson 3: Publishing

Creating Publications

Using the Immediate updating Subscribers Option

Publishing Comsiderations

Initial Synchronization

Editing Publication Properties

Agents Created for a Publication

Lesson Summary

Lesson 4: Subscribing

Setting Up Push and Pull Subscriptions

Using the Immediate Updating Subscribers Option

Editing Subscription Properties

Agents Creatde for a Subscription

Lesson Summary

Review

Chapter 17 manahing Replication

About This Chaper

Before You Begin

Lesson 1: Monitoring and Troubleshooting Replication

Using SQL Server Replication Monitor

Maintaining Replication

Using Replication scripts

Monitoring SQL Server Replication Performance

Troubleshooting Replication

Lesson Summary

Lesson 2: Replicating in Heterogeneous Environments

Replicating Data with ODBC

Publishing Data to Heterogeneous Subscribers

Replicating from Heterogeneous Databases

Making a Publication Available on the Internet

Lesson Summary

Review

Appendix A Questions and Answers

Appendix B Database Schemata

Glossary

Index