Microsoft® SQL Server High Availability

Microsoft® SQL Server High Availability

by Paul Bertucci
Released November 2004
Publisher(s): Sams
ISBN: 9780672326257

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Offers example-based coverage for various high availability solutions.

  • High availability is becoming an increasingly important topic for database administrators, data architects and system architects.

  • Covers choosing, planning, implementing and administering a high availability solution along with the business justifications.

  • Paul Bertucci has over 20 years of database experience including consulting for numerous Fortune 500 companies.

    •

    Table of contents

    1. Copyright
    2. About the Author
    3. Acknowledgments
      1. References:
    4. We Want to Hear from You!
    5. Introduction
    6. Essential Elements of High Availability
      1. Overview of High Availability
      2. Calculating “Availability”
      3. Availability Continuum
      4. Availability Variables
      5. General Design Approach for Achieving High Availability
      6. High Availability Business Scenarios (Applications)
      7. Microsoft Technologies that Yield High Availability
      8. Summary
    7. Microsoft High Availability Options
      1. What High Availability Options Are There?
      2. Building Your HA Solution with One or More of These Options
      3. Summary
    8. Choosing High Availability
      1. Moving Toward High Availability
      2. Step 1—Launching a Phase 0 (Zero) HA Assessment
      3. Step 2—HA Primary Variables Gauge
      4. Step 3—Determining the Optimal HA Solution
      5. Summary
    9. Microsoft Cluster Services
      1. Understanding Microsoft Cluster Services
      2. Hardware/Network/OS Requirements for MSCS
      3. How Clustering Actually Works
      4. Installing MSCS
      5. Windows 2003 Options for Quorum Disks and Fail-over
      6. 4-node and 8-node Clustering Topologies
      7. Summary
    10. Microsoft SQL Server Clustering
      1. Microsoft SQL Clustering Core Capabilities
      2. Installing SQL Clustering
      3. Failure of a Node
      4. Removing SQL Clustering
      5. Client Test Program for a SQL Cluster
      6. A Node Recovery
      7. Application Service Provider—Scenario #1 with SQL Clustering
      8. Summary
    11. Microsoft SQL Server Log Shipping
      1. Microsoft Log Shipping Overview
      2. Setting Up Log Shipping
      3. Call Before You Dig—Scenario #4 with Log Shipping
      4. Summary
    12. Microsoft SQL Server Data Replication
      1. Microsoft SQL Server Data Replication Overview
      2. What Is Data Replication?
      3. The Publisher, Distributor, and Subscriber Metaphor
      4. Replication Scenarios
      5. Subscriptions
      6. The Distribution Database
      7. Replication Agents
      8. Planning for SQL Server Data Replication
      9. SQL Server Replication Types
      10. User Requirements Drive the Replication Design
      11. Setting Up Replication
      12. Switching Over to a Warm Standby (Subscriber)
      13. Scripting Replication
      14. Monitoring Replication
      15. Summary
    13. Other Ways to Distribute Data for High Availability
      1. Alternate Ways to Achieve High Availability
      2. Distributed Transactions
      3. MS DTC Architecture
      4. COM+ Applications for HA
      5. Summary
    14. High Availability Pieced Together
      1. Achieving Five 9s
      2. Foundation First
      3. Assemble Your HA Assessment Team
      4. Set the HA Assessment Project Schedule/Timeline
      5. Doing a Phase 0 High Availability Assessment
      6. Selecting the HA Solution
      7. Is the HA Solution Cost Effective?
      8. Summary
    15. High Availability Design Issues and Considerations
      1. Things to Consider for High Availability
      2. General SQL Server File/Device Placement Recommendations
      3. Database Backup Strategies in Support of High Availability
      4. Disaster Recovery Planning
      5. Software Upgrade Considerations
      6. High Availability and MS Analysis Services/OLAP
      7. Alternative Techniques in Support of High Availability
      8. Summary
    16. High Availability and Security
      1. Security Breakdowns' Effect on High Availability
      2. Proper Security in Place for HA Options
      3. Summary
    17. Future Directions of High Availability
      1. Microsoft Stepping Up to the Plate
      2. What's Coming in Yukon for High Availability?
      3. Data Access Enhancements for Higher Availability
      4. High Availability from the Windows Server Family Side
      5. Other Industry Trends in High Availability
      6. Summary
    18. Microsoft Windows Server System Series
    19. Index

    Product information

    • Title: Microsoft® SQL Server High Availability
    • Author(s): Paul Bertucci
    • Release date: November 2004
    • Publisher(s): Sams
    • ISBN: 9780672326257