List of Figures

Chapter 1: Architecture and Installation

Figure 1-1: Upgrading to SQL Server 2000.

Chapter 2: Managing SQL Server

Figure 2-1: Set memory controls instead of relying on automatic processes.

Chapter 4: Optimizing and Automating SQL Server Administration

Figure 4-1: Use Enterprise Manager to add and operator

Figure 4-2: Use the New Job Properties dialog box to configure a job.

Figure 4-3: Transformations tab with auto-mapping

Figure 4-4: Transformations tab after optimization

Figure 4-5: Use the Logging tab to configure logging

Chapter 5: Monitoring and Tuning SQL Server

Figure 5-1: Adding counters in System Monitor

Figure 5-2: System Monitor uses color codes, which you can't see here, for tracking individual counters

Figure 5-3: Setting up a log file

Figure 5-4: Scheduling logs

Figure 5-5: Click View Report to see average activity reports

Figure 5-6: Creating a sample alert with a simple interval of 30 seconds

Figure 5-7: Configuring the alert to send a message and start the log when it is triggered

Figure 5-8: Message received when the alert has been triggered

Figure 5-9: Adding trace flags to execute at startup

Figure 5-10: Creating an alert

Figure 5-11: Select the conditions for job notifications

Chapter 6: Automating Administrative Tasks

Figure 6-1: Replacing parameters in a template

Figure 6-2: Adding an extended stored procedure

Figure 6-3: Simple online publisher's database schema

Figure 6-4: Setting a table-level extended property

Figure 6-5: Modifying an extended property in Query Analyzer

Chapter 7: Optimizing and Troubleshooting SQL Server

Figure 7-1: Set Pagefile.sys to a static number

Figure 7-2: Network card sleep settings

Figure 7-3: Rearranging the network protocols

Figure 7-4: Adding an alias in Client Network Utilities

Figure 7-5: Creating a new trace

Figure 7-6: Specifying the events to trap

Figure 7-7: Specifying the columns to capture

Chapter 8: Disaster Planning and Recovery

Figure 8-1: Backing up a database in Enterprise Manager

Figure 8-2: Options tab of backup creation

Figure 8-3: Error received when attempting to overwrite a backup media set

Figure 8-4: Database options in Enterprise Manager

Figure 8-5: Restore Database screen

Figure 8-6: Restoring a differential database backup

Figure 8-7: Detaching a database in Enterprise Manager

Figure 8-8: Attaching a database in Enterprise Manager

Chapter 9: Scaling SQL Server

Figure 9-1: The basic architecture behind linked servers

Figure 9-2: Creating a linked server

Figure 9-3: Configuring linked server security

Figure 9-4: Configuring linked servers in Enterprise Manager

Figure 9-5: Distributed partitioned view architecture

Chapter 10: High Availability in SQL Server

Figure 10-1: Log shipping basic architecture

Figure 10-2: Selecting the database and beginning the log shipping process

Figure 10-3: Specify Transaction Log Backup Disk Directory screen

Figure 10-4: Specifying the transaction log backup share

Figure 10-5: Adding destinations in the Specify Log Shipping Destinations screen

Figure 10-6: Adding and configuring a destination database

Figure 10-7: Initializing the Destination Databases screen

Figure 10-8: Setting the frequency of the copying and restoring of your transaction logs

Figure 10-9: Setting the log shipping thresholds

Figure 10-10: Setting the log shipping monitor

Figure 10-11: Completing the Database Maintenance Plan Wizard

Figure 10-12: Status tab on the Log Shipping Pair Properties screen on the monitored server

Figure 10-13: Source tab in the Log Shipping Pair Properties screen

Figure 10-14: Destination tab in the Log Shipping Pair Properties screen

Figure 10-15: Error in event log when database is out of synch

Figure 10-16: Error in SQL Server Log when a log shipped database is not backed up

Figure 10-17: Logins tab in the Transfer Logins Task

Figure 10-18: Basic clustering configuration

Figure 10-19: Minimum supportable cluster configuration

Figure 10-20: Minimum recommended cluster configuration

Figure 10-21: No communication single point of failure server configuration

Chapter 11: Clustering Windows and SQL Server

Figure 11-1: The Select Partition Type screen

Figure 11-2: Formatting and naming the drive

Figure 11-3: Starting the Cluster Service Configuration Wizard

Figure 11-4: Hardware Configuration screen

Figure 11-5: Create of Join a Cluster screen

Figure 11-6: Assigning the cluster name

Figure 11-7: Selecting the account to start MSCS

Figure 11-8: Selecting the drives that will be clustered

Figure 11-9: Selecting the cluster disk

Figure 11-10: Selecting the heartbeat connection

Figure 11-11: Selecting the public connection

Figure 11-12: Selecting the private connection for the cluster

Figure 11-13: Setting the cluster's IP address and network

Figure 11-14: Joining an existing Cluster Name screen

Figure 11-15: Security confirmation in the Select an Account screen

Figure 11-16: Cluster Administration before you configure the resource groups

Figure 11-17: Creating a new cluster group

Figure 11-18: Specify the preferred owners of the group and their priority

Figure 11-19: Cluster Administrator after resource group configuration

Figure 11-20: Installing MS DTC in a cluster using comclust.exe

Figure 11-21: Naming the SQL Server virtual server

Figure 11-22: Assigning a VIPA to the SQL Server name

Figure 11-23: Choosing a data drive for SQL Server

Figure 11-24: Defining who are possible owners of the SQL Server instance

Figure 11-25: Setting up the account to copy the files

Figure 11-26: Cluster Administrator after the complete installation

Figure 11-27: Setting up the disk dependencies

Figure 11-28: Adding additional resources drives as dependencies

Figure 11-29: Advanced resource options

Figure 11-30: The resource group's Failover tab

Figure 11-31: The resource group's Failback tab

Figure 11-32: Choosing the virtual SQL Server name to install the service pack on

Figure 11-33: Remote Information screem

Chapter 12: SQL Server Replication

Figure 12-1: Publisher/distributor replication model

Figure 12-2: Snapshot replication model

Figure 12-3: Merge replication model

Figure 12-4: Transactional replication model

Figure 12-5: Bidirectional replication model

Figure 12-6: Publisher Properties screen

Figure 12-7: Configuring the schedules

Figure 12-8: Selecting objects to publish

Figure 12-9: Commands tab in the Table Article Properties screen

Figure 12-10: Snapshot tab in the Table Article Properties screen

Figure 12-11: Applying filters to a publication

Figure 12-12: Resolver tab in merge replication

Figure 12-13: Conflict Resolver priority code