List of Tables

Chapter 1: Preparing for High Availability

Table 1-1: Nines Calculations (Per Year), in Descending Order

Chapter 3: Making a High Availability Technology Choice

Table 3-1: Cluster Nodes Supported Per Operating System

Table 3-2: SQL Server Node Support per Version

Table 3-3: SQL Server Availability Technology Comparison Table

Chapter 4: Disk Configuration for High Availability

Table 4-1: CustomerInfo Table

Table 4-2: Performance Counters

Table 4-3: Databases Used by Sample Application

Table 4-4: Breakdown of File Sizes

Table 4-5: Available Raw Drive Space

Table 4-6: Sample 1

Table 4-7: Sample 2

Table 4-8: Sample 3

Table 4-9: Sample 4

Table 4-10: Sample 5

Chapter 5: Designing Highly Available Microsoft Windows Servers

Table 5-1: Memory and Processors Supported per Operating System

Table 5-2: Numbers of Nodes and Failure Tolerance in a Majority Node Set Cluster

Table 5-3: Supported Deviations from Windows Catalog

Chapter 6: Microsoft SQL Server 2000 Failover Clustering

Table 6-1: Virtual Server Names on a Single Server Cluster

Table 6-2: Number of Nodes Available

Table 6-3: SQL Server Service Account Privileges Needed

Chapter 7: Log Shipping

Table 7-1: Table Usage for Log Shipping

Table 7-2: Log Shipping Parameters and Recommended Values

Chapter 8: Replication

Table 8-1: Agents Per Model of Replication

Table 8-2: File Types Associated with Replication

Table 8-3: Disk Requirements for Replication

Table 8-4: Replication Disaster Recovery Scenarios

Chapter 9: Database Environment Basics for Recovery

Table 9-1: SQL Server 2000 Recovery Models

Table 9-2: SELECT INTO Operation

Table 9-3: UPDATE Operation

Table 9-4: Changing Recovery Models and Impact on Backups

Table 9-5: Backup Naming Conventions

Chapter 10: Implementing Backup and Restore

Table 10-1: Example Output

Table 10-2: Output Returned for All of the Backups

Chapter 11: Real-World High Availability Solutions

Table 11-1: Planning the Disk Subsystem

Table 11-2: New Server Configuration

Chapter 12: Disaster Recovery Techniques for Microsoft SQL Server

Table 12-1: Databases

Table 12-2: Database Dependencies and Impact on Solution Availability

Chapter 14: Administrative Tasks for High Availability

Table 14-1: Routine Maintenance Commands

Table 14-2: Medium Impact Commands

Table 14-3: Intrusive Maintenance Commands

Table 14-4: Memory Supported for 32-Bit Versions of Windows with PAE

Table 14-5: Memory Supported for 64-bit Versions of Windows (No Boot.ini Modifications Necessary)

Table 14-6: Memory Recommendations for a 32-Bit SQL Server 2000 Instance

Chapter 15: Monitoring for High Availability

Table 15-1: What Do You Want to Know Now?

Table 15-2: What Do You Want to Know Later?

Table 15-3: Monitoring Tools for System Layers

Table 15-4: Sample Reports

Table 15-5: Availability by Function

Table 15-6: Sysperfinfo Table Contents