Administering SQL Server Overview
 Starting, Pausing, and Stopping SQL Server
    Starting SQL Server
       Starting SQL Server Automatically
       Starting SQL Server Manually
       Starting SQL Server in Single-User Mode
       Starting SQL Server with Minimal Configuration
       Using Startup Options
    Logging In to SQL Server
    Running SQL Server
    Pausing and Resuming SQL Server
    Stopping SQL Server
       Broadcasting a Shutdown Message
 Failover Clustering
    Failover Clustering Support
    Creating a Failover Cluster
       Failover Clustering Example
    Upgrading to a SQL Server 2000 Failover Cluster
    Handling a Failover Cluster Installation
       Before Installing Failover Clustering
       Installing Failover Clustering
       Failover Clustering Dependencies
    Maintaining a Failover Cluster
    Using SQL Server Tools with Failover Clustering
    Failover Cluster Troubleshooting
 Importing and Exporting Data
    Choosing a Tool to Import or Export Data
    Preparing Data for Importing and Exporting
    Using bcp and BULK INSERT
       Using Native, Character, and Unicode Formats
          Native Format
          Character Format
          Copying Native and Character Format Data from Earlier Versions of SQL Server
          Unicode Character Format
          Unicode Native Format
       Specifying Data Formats
          File Storage Type
          Prefix Length
          Field Length
          Field Terminator
       Using Format Files
          Using a Data File with Fewer Fields
          Using a Data File with More Fields
          Using a Data File with Fields in a Different Order
       Copying Data
          Copying Data Between Servers
          Copying Data From a Data File to SQL Server
          Copying Data From a Query to a Data File
          Copying Data To or From a Temporary Table
          Copying Data To or From a View
          Copying Data Between Different Collations
       Bulk Copy Performance Considerations
          The Query Processor
          Logged and Minimally Logged Bulk Copy Operations
          Parallel Data Loads
          Batch Switches
          Constraint Checking
          Ordered Data Files
          Bypassing DEFAULT Definitions
          Controlling the Locking Behavior
 Backing Up and Restoring Databases
    Designing a Backup and Restore Strategy
       Analyzing Availability and Recovery Requirements
       Planning for Disaster Recovery
       Selecting a Recovery Model
    Using Recovery Models
       Simple Recovery
       Full Recovery
       Bulk-Logged Recovery
       Switching Recovery Models
    Backup and Restore Operations
       Database Backups
       Differential Database Backups
       Transaction Log Backups
       Backup Restrictions
       Restoring a Database to a Prior State
          Recovering to a Point In Time
          Recovering to a Named Transaction
          Recovery Paths
       Partial Database Restore Operations
       Recovering a Database Without Restoring
       Restarting Interrupted Backup and Restore Operations
          Backup and Recovery of Related Databases
    Managing Backups
       Backup Devices
       Using Backup Media
          Using Media Sets and Families
          Initializing Backup Media
          Password Protection
          Overwriting Backup Media
          Appending Backup Sets
          Identifying the Backup Set to Restore
       Backup Formats
       Viewing Information About Backups
       Verifying Backups
    Backing Up and Restoring System Databases
       Backing Up the master Database
       Restoring the master Database
          Restoring the master Database from a Current Backup
          Rebuilding the master Database
       Backing Up the model, msdb, and distribution Databases
       Restoring the model, msdb, and distribution Databases
    Handling Large Mission-Critical Environments
       Using Multiple Media or Devices
       Reducing Recovery Time
       Using File Backups
          File Differential Backups
       Snapshot Backups
    Copying Databases to Other Servers
       Copying Databases
       Copying Databases from Earlier Versions of SQL Server
 Using the Copy Database Wizard
 Managing Servers
    Registering Servers
       Creating Server Groups
       Accessing Server Registration Options
    Assigning an sa Password
    Managing AWE Memory
    Configuring Network Connections
       Net-Libraries and Network Protocols
       SQL Server Network Utility
       Connections to SQL Server Through Proxy Server
       Connections to SQL Server Over the Internet
    Configuring Linked Servers
       Establishing Security for Linked Servers
       Configuring OLE DB Providers for Distributed Queries
    Configuring Remote Servers
       Establishing Security for Remote Servers
       Viewing Local or Remote Server Properties
    Using Standby Servers
    Log Shipping
       Modifying Log Shipping
       Monitoring Log Shipping
    Concurrent Administrative Operations
    Managing SQL Server Messages
    SQL Mail
       Configuring SQL Mail
       Configuring Mail Profiles
       Using SQL Mail Stored Procedures
    Setting Configuration Options
       affinity mask Option
       allow updates Option
       awe enabled Option
       c2 audit mode Option
       cost threshold for parallelism Option
       cursor threshold Option
       default full-text language Option
       default language Option
       fill factor Option
       index create memory Option
       lightweight pooling Option
       locks Option
       max degree of parallelism Option
       max text repl size Option
       max worker threads Option
       media retention Option
       min memory per query Option
       nested triggers Option
       network packet size Option
       open objects Option
       priority boost Option
       query governor cost limit Option
       query wait Option
       recovery interval Option
       remote access Option
       remote login timeout Option
       remote proc trans Option
       remote query timeout Option
       scan for startup procs Option
       Server Memory Options
       set working set size Option
       show advanced options Option
       two digit year cutoff Option
       user connections Option
       user options Option
 Managing Clients
    Client Net-Libraries and Network Protocols
    Configuring Client Network Connections
    Configuring Client Net-Libraries
       Setting Up Client Configuration Entries
          TCP/IP Sockets Clients
          Named Pipes Clients
          Multiprotocol Clients
          NetWare Link IPX/SPX Clients
          AppleTalk ADSP Clients
          Banyan VINES Clients
          VIA Clients
          Other Network Protocol Clients
    Configuring ODBC Data Sources
       Using the ODBC Data Source Administrator
       Using ODBC API Functions
       Adding or Deleting an ODBC Data Source
    Configuring OLE DB Clients
    DB-Library Options
       Using the DB-Library Automatic ANSI to OEM Conversion Option
          Checking the Validity of Saved Data
          Code Page Incompatibilities
 Automating Administrative Tasks
    Multiserver Administration
    Configuring the SQLServerAgent Service
       Starting SQLServerAgent Service
       Connecting to SQL Server
       Specifying a SQL Server Alias
    Using the SQL Server Agent Error Log
    Implementing Jobs
       Creating Jobs
       Creating Job Steps
       Handling Multiple Job Steps
       Scheduling Jobs
       Specifying Job Responses
       Running Jobs
       Modifying and Viewing Jobs
       Scripting Jobs Using Transact-SQL
    Responding to Events
       Defining Operators
       Modifying and Viewing Operators
       Alerting Operators
       Defining Alerts
       Modifying and Viewing Alerts
       Copying Operators or Alerts to Other Servers
       Managing Events
    Monitoring the Environment
 Managing Security
    Security Architecture
    Planning Security
       Single Person Security Example
       Small Company Security Example
       Corporate Environment Security Example
    Security Levels
       Authentication Modes
       Security Account Delegation
       Permissions Validation
       Hierarchical Security
    Creating Security Accounts
       Security Rules
       Adding a Windows User or Group
          Granting a Windows User or Group Access to a Database
       Adding a SQL Server Login
          System Administrator (sa) Login
          Granting a SQL Server Login Access to a Database
       Database Owner (dbo)
       Database Object Owner
       guest User
       Creating User-Defined SQL Server Database Roles
       Adding a Member to a SQL Server Database Role
       Adding a Member to a Predefined Role
          public Role
       Using the Create Login Wizard
    Managing Security Accounts
       Viewing Logins
       Modifying Logins
       Removing Logins and Users
       Denying Login Access to Windows Accounts
       Viewing Roles
       Viewing and Modifying Role Memberships
       Removing a SQL Server Database Role
       Viewing Database Users
    Managing Permissions
       Granting Permissions
       Denying Permissions
       Revoking Permissions
       Resolving Permission Conflicts
          Permissions for User-Defined Functions
       Using Ownership Chains
          Using Views as Security Mechanisms
          Using Stored Procedures as Security Mechanisms
    Advanced Security Topics
       Establishing Application Security and Application Roles
       Allowing Other Accounts to Grant Object Permissions
       Creating SQL Server File Permissions
       Using Encryption Methods
       Revealing SQL Server on a Network
       Scripting Data Access Controls in Internet Explorer
    Auditing SQL Server Activity
       Using Audit Logs
       C2 Auditing
 Monitoring Server Performance and Activity
    Evaluating Performance
       Establishing a Performance Baseline
       Identifying Bottlenecks
       Determining User Activity
    Choosing a Monitoring Tool
    Monitoring with SQL Profiler
       SQL Profiler Keyboard Shortcuts
       SQL Profiler Terminology
       SQL Profiler Scenarios
       Monitoring with SQL Profiler Event Categories
          SQL Profiler Event Classes
             SQL Profiler Default Event Classes
          SQL Profiler Data Columns
          Cursors Event Category
             Cursors Event Classes
             Cursors Data Columns
          Database Event Category
             Database Event Classes
             Database Data Columns
          Errors and Warnings Event Category
             Errors and Warnings Event Classes
             Errors and Warnings Data Columns
          Locks Event Category
             Locks Event Classes
             Locks Data Columns
          Objects Event Category
             Objects Event Classes
             Objects Data Columns
          Performance Event Category
             Performance Event Classes
             Performance Data Columns
          Scans Event Category
             Scans Event Classes
             Scans Data Columns
          Security Audit Event Category
             Security Audit Event Classes
             Security Audit Data Columns
          Sessions Event Category
             Sessions Event Classes
             Sessions Data Columns
          Stored Procedures Event Category
             Stored Procedures Event Classes
             Stored Procedures Data Columns
          Transactions Event Category
             Transactions Event Classes
             Transactions Data Columns
          TSQL Event Category
             TSQL Event Classes
             TSQL Data Columns
          User Configurable Event Category
             User Configurable Event Classes
             User Configurable Data Columns
       Creating and Managing Traces and Templates
          Limiting Traces
             Maximum File and Data Size
             Datetime Filter
             System SPID
          Saving Traces and Templates
          Modifying Templates
          Starting, Pausing, and Stopping Traces
          Viewing and Analyzing Traces
          Replaying Traces
             Single-Stepping Traces
          Deleting Traces
       SQL Profiler Performance Considerations
    Monitoring with System Monitor
       Monitoring Disk Activity
       Monitoring CPU Usage
       Monitoring Memory Usage
       Creating a SQL Server Database Alert
       System Monitor Scenarios
       Running System Monitor
       Creating Charts, Alerts, Logs, and Reports
       Using SQL Server Objects
          SQL Server: Access Methods Object
          SQL Server: Backup Device Object
          SQL Server: Buffer Manager Object
          SQL Server: Buffer Partition Object
          SQL Server: Cache Manager Object
          SQL Server: Databases Object
          SQL Server: General Statistics Object
          SQL Server: Latches Object
          SQL Server: Locks Object
          SQL Server: Memory Manager Object
          SQL Server: Replication Agents Object
          SQL Server: Replication Distribution Object
          SQL Server: Replication Logreader Object
          SQL Server: Replication Merge Object
          SQL Server: Replication Snapshot Object
          SQL Server: SQL Statistics Object
          SQL Server: User Settable Object
    Monitoring with SQL Server Enterprise Manager
    Monitoring the Error Logs
       Viewing the SQL Server Error Log
       Viewing the Windows Application Log
    Monitoring with Transact-SQL Statements
    Monitoring with SNMP
       SNMP Terminology
       Enabling SNMP Support on SQL Server
       Enabling SQL Server Support of SNMP on Windows 98
       Enabling SQL Server MIB
 Using the Web Assistant Wizard
    Configuring the Web Assistant Wizard
    Receiving Query Results with the Web Assistant Wizard