You are previewing SQL Server 2000 High Availability Volume 1: Planning.
O'Reilly logo
SQL Server 2000 High Availability Volume 1: Planning

Book Description

The SQL Server 2000 High Availability Planning Guide helps database designers and systems engineers design data centers that can achieve the level of availability needed for particular business environments.

Table of Contents

  1. Microsoft® SQL Server 2000 High Availability, Volume 1: Planning
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. Preface
      1. System Requirements
      2. Document Conventions
      3. Acknowledgments
    3. 1. Introduction to High Availability
      1. Microsoft SQL Server 2000 High Availability Series
        1. Planning Guide
        2. Solution Guide
      2. Understanding High Availability
      3. Designing a High-Availability Data Center
        1. Setting High-Availability Goals
        2. Identifying and Analyzing Barriers to High Availability
        3. Determining and Evaluating High-Availability Solutions
    4. 2. Overcoming Barriers to High Availability
      1. Overcoming Environmental Barriers
      2. Overcoming Hardware Barriers
      3. Overcoming Communication and Connectivity Barriers
      4. Overcoming Software Barriers
      5. Overcoming Service Barriers
      6. Overcoming Process Barriers
        1. Process Management
        2. Incident Management
          1. Diagnosing a Failure
          2. Response-Time Practices
          3. Monitoring Practices
        3. Change Management
          1. Planned Changes
          2. Emergency Changes
        4. Maintenance Management
        5. Configuration Management
          1. Services
          2. Security
      7. Overcoming Application Design Barriers
      8. Overcoming Staffing Barriers
    5. 3. Recovering a Data Center by Using Database Backups
      1. Solving High-Availability Barriers Using Backups
        1. Storage Subsystem Failure
        2. Application or User Errors
      2. Developing a Backup-and-Recovery Solution
        1. Measuring Total Recovery Time
        2. Improving Total Recovery Time
          1. Data Disks
          2. Backup Devices
          3. Adjusting the Frequency and Type of Database Backup
      3. Using a Third-Party Backup-and-Recovery Solution
        1. Using Snapshots to Improve the Recovery Time
          1. Split-Mirror Snapshots
          2. Copy-on-Write Snapshots
        2. Using Third-Party Solutions to Increase Functionality
    6. 4. Preventing Downtime by Using Redundant Components
      1. Using Server-Class Hardware
      2. Using a Redundant Storage Subsystem
        1. RAID
          1. Striping
          2. Mirroring
          3. Striping with Distributed Parity
          4. Striped Mirroring
          5. Mirrored Striping
        2. Controller Cards
        3. Data and Log File Placement
      3. Using Redundant Network Cards
    7. 5. Minimizing Downtime by Using Redundant Servers
      1. Using Failover Clustering to Maintain a Redundant Server
        1. Failover Clustering Architecture
        2. Failover Clustering Advantages
        3. Failover Clustering Limitations and Disadvantages
      2. Using Log Shipping to Maintain a Redundant Server
        1. Log Shipping Architecture
        2. Firewall Considerations
        3. Log Shipping Role Change
        4. Log Shipping Advantages
        5. Log Shipping Limitations and Disadvantages
      3. Using Transactional Replication to Maintain a Redundant Server
        1. Transactional Replication Architecture
        2. Firewall Considerations
        3. Transactional Replication Role Change
        4. Transactional Replication Advantages
        5. Transactional Replication Limitations and Disadvantages
      4. Redirecting Client Network Traffic to a Promoted Secondary Server
      5. Choosing Among the Technology Solutions
      6. Summary
    8. A. Contents of a Run Book
      1. Resource Information
        1. Contact Information
        2. Hardware Components
        3. Software Components
      2. Procedural Information
        1. Operational Tasks
        2. Emergency Tasks
    9. Index
    10. SPECIAL OFFER: Upgrade this ebook with O’Reilly