Wiley SQL Server 2008 Administration Instant Reference 978-0-470-49660-2 用户手册
产品代码
978-0-470-49660-2
Part I: SQL Server Basics
1
Chapter 1: Installing SQL Server 2008
3
Prepare for Installation
4
SQL Server in the Enterprise
4
SQL Server Editions
9
SQL Server 2008 Licensing
16
Installation Requirements
17
Install SQL Server 2008
20
Performing a Standard Installation
21
Verifying a Standard Installation
32
Performing an Unattended Installation
37
Chapter 2: Configuring SQL Server 2008
41
Configure the Server Platform
42
Configuring System Memory
42
Planning System Redundancy
46
Configure SQL Server 2008
50
Configuring the Server with the SSMS
50
Configuring the Server with TSQL
64
Configuring the Services
66
Chapter 3: Creating Databases, Files, and Tables
75
Perform Capacity Planning
76
SQL Server I/O Processes
77
Disk Capacity Planning
79
Memory Capacity Planning
82
Create and Alter Databases
83
Create a Database
84
Alter a Database
92
Drop a Database
96
Manage Database Files
98
Add Files to a Database
98
Add Files to a Filegroup
101
Contents
Introduction
xiii
96602book.indb 7
7/23/09 4:04:16 PM
COPYRIGHTED MATERIAL