Home > Store

Microsoft SQL Server High Availability

Register your product to gain access to bonus material or receive a coupon.

Microsoft SQL Server High Availability


  • Your Price: $31.99
  • List Price: $39.99
  • We're temporarily out of stock, but order now and we'll send it to you later.


  • Copyright 2005
  • Edition: 1st
  • Book
  • ISBN-10: 0-672-32625-6
  • ISBN-13: 978-0-672-32625-7

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.



All the files used for the examples in the book - 188 KB --examples.zip

Sample Content

Online Sample Chapters

Choosing High Availability

Making Your SQL Server Apps Highly Available: First, Do The Assessment

Table of Contents


    Five 9s.

    Who Is This Book's Intended Audience?

    How This Book Is Organized.

    Conventions Used in This Book.

    Setting Your Goals High!


1. Essential Elements of High Availability.

    Overview of High Availability.

    Calculating "Availability".

      Availability Example-A 24/7/365 Application.

    Availability Continuum.

    Availability Variables.

    General Design Approach for Achieving High Availability.

      Development Methodology with High Availability "Built In".

      Assessing Existing Applications.

      Service Level Agreement.

    High Availability Business Scenarios (Applications).

      Application Service Provider.

      Worldwide Sales and Marketing-Brand Promotion.

      Investment Portfolio Management.

      Call Before You Dig.

    Microsoft Technologies that Yield High Availability.



2. Microsoft High Availability Options.

    What High Availability Options Are There?

      Fundamental Areas to Start With.

      Fault Tolerant Disk: RAID and Mirroring.

      Redundant Array of Independent Disks (RAID).

      Mitigate Risk by Spreading Out Server Instances.

     Building Your HA Solution with One or More of These Options.

      Microsoft Cluster Services (MSCS).

      SQL Clustering.

      Data Replication.

      Log Shipping.

      Distributed Transactions.


3. Choosing High Availability.

    Moving Toward High Availability.

    Step 1-Launching a Phase 0 (Zero) HA Assessment.

      Resources for a Phase 0 HA Assessment.

      The Phase 0 HA Assessment Tasks.

    Step 2-HA Primary Variables Gauge.

    Step 3-Determining the Optimal HA Solution.

       A Hybrid High Availability Selection Method.

      Cost Justification of a Selected High Availability Solution.

      Adding HA Elements to Your Development Methodology.



4. Microsoft Cluster Services.

    Understanding Microsoft Cluster Services.

    Hardware/Network/OS Requirements for MSCS.

    How Clustering Actually Works.

      The Disk Controller Configuration.

      The Disk Configuration.

      Network Configuration.

      Considerations at the Operating System Level.

    Installing MSCS.


      Installing MSCS-Step 1.

      Installing MSCS for the Next Node: Step 2.

      Extending Clustering with Network Load Balancing (NLB).

    Windows 2003 Options for Quorum Disks and Fail-over.

    4-node and 8-node Clustering Topologies.


5. Microsoft SQL Server Clustering.

    Microsoft SQL Clustering Core Capabilities.

      SQL Clustering Is Built on MSCS.

      Configuring MS DTC for Use with SQL Clustering.

      Laying Out a SQL Cluster Configuration.

    Installing SQL Clustering.

    Failure of a Node.

    Removing SQL Clustering.

    Client Test Program for a SQL Cluster.

    A Node Recovery.

    Application Service Provider-Scenario #1 with SQL Clustering.


6. Microsoft SQL Server Log Shipping.

    Microsoft Log Shipping Overview.

      Data Latency and Log Shipping.

      Design and Administration Implications of Log Shipping.

    Setting Up Log Shipping.

      Before Creating the Log Shipping DB Maintenance Plan.

      Using the DB Maintenance Plan Wizard to Create.

      Log Shipping.

      Viewing Log Shipping Properties.

      Changing the Primary Role.

      Log Shipping System Stored Procedures.

    Call Before You Dig-Scenario #4 with Log Shipping.


7. Microsoft SQL Server Data Replication.

    Microsoft SQL Server Data Replication Overview.

    What Is Data Replication?

    The Publisher, Distributor, and Subscriber Metaphor.

      Publications and Articles.

      Filtering Articles.

    Replication Scenarios.

      Central Publisher.

      Central Publisher with Remote Distributor.

      Publishing Subscriber.

      Central Subscriber.

      Multiple Publishers or Multiple Subscribers.

      Updating Subscribers.


      Pull Subscriptions.

      Push Subscriptions.

      Anonymous Subscriptions (Pull Subscriptions).

    The Distribution Database.

    Replication Agents.

      The Snapshot Agent.

      The Log Reader Agent.

      The Distribution Agent.

      The Merge Agent.

      The Miscellaneous Agents.

    Planning for SQL Server Data Replication.

      Timing, Latency, and Autonomy of Data.

      Methods of Data Distribution.

    SQL Server Replication Types.

      Snapshot Replication.

      Transactional Replication.

      Merge Replication.

    User Requirements Drive the Replication Design.

    Setting Up Replication.

      Enable a Distributor.

      Enable Publishing/Configure the Publisher.

      Creating a Publication.

      Creating Subscriptions.

    Switching Over to a Warm Standby (Subscriber).

      Scenarios That Will Dictate Switching to the Warm Standby.

      Switching Over to a Warm Standby (Subscription).

      Turning the Subscriber into a Publisher (if Needed).

      Insulate the Client Using an NLB Cluster Configuration.

    Scripting Replication.

    Monitoring Replication.

      SQL Statements.

      SQL Enterprise Manager.

      The Performance Monitor.

      Backup and Recovery in a Replication Configuration.

      Alternate Synchronization Partners.

      Worldwide Sales and Marketing-Scenario #2 with Data Replication.


8. Other Ways to Distribute Data for High Availability.

    Alternate Ways to Achieve High Availability.

      A Distributed Data Approach from the Outset.

      Setting Up Access to Remote SQL Servers.

      Querying a Linked Server.

      Transact-SQL with Linked Servers.

    Distributed Transactions.

    MS DTC Architecture.

      Two-Phase Commit Protocol.

    COM+ Applications for HA.


9. High Availability Pieced Together.

    Achieving Five 9s.

    Foundation First.

    Assemble Your HA Assessment Team.

    Set the HA Assessment Project Schedule/Timeline.

    Doing a Phase 0 High Availability Assessment.

      Step 1-HA Assessment.

      Step 2-Primary Variable Gauge Specification.

      High Availability Tasks Integrated into Your Development Life Cycle.

    Selecting the HA Solution.

    Is the HA Solution Cost Effective?


10. High Availability Design Issues and Considerations.

    Things to Consider for High Availability.

      Hardware/OS/Network Design Considerations.

      Remote Mirroring.

      Microsoft Cluster Services Design Considerations.

      SQL Server Clustering Design Considerations.

      Stretch Clustering.

      SQL Server Data Replication Design Considerations.

      SQL Server Log Shipping Design Considerations.

      Distributed Transaction Processing Design Considerations.

    General SQL Server File/Device Placement Recommendations.

    Database Backup Strategies in Support of High Availability.

      Two Backup Approaches for High Availability.

      Parallel Striped Backup.

      Split-Mirror Backups (Server-less Backups).

      Volume Shadow Copy Service (VSS).

      Monitoring/Verifying Backups.

    Disaster Recovery Planning.

      The Overall Disaster Recovery Approach.

      The Focus for Disaster Recovery.

      Documenting Environmental Details Using SQLDIAG.EXE.

      Plan and Execute a Complete Disaster Recovery test.

    Software Upgrade Considerations.

    High Availability and MS Analysis Services/OLAP.

      OLAP Cubes Variations.

      Recommended MSAS Implementation for High Availability.

    Alternative Techniques in Support of High Availability.

      Data Transformation Service (DTS) Packages Used to Achieve HA.

      Have You Detached a Database Recently?

      Third-party Alternatives to High Availability.

      IBM/DB2 High Availability Example.


11. High Availability and Security.

    Security Breakdowns' Effect on High Availability.

      Using an Object Permissions and Roles Method.

      Object Protection Using Schema-Bound Views.

    Proper Security in Place for HA Options.

      MSCS Security Considerations.

      SQL Clustering Security Considerations.

      Log Shipping Security Considerations.

      Data Replication Security Considerations.

      General Thoughts on Database Backup/Restore.

      Isolating SQL Roles, and Disaster Recovery Security Considerations.


12. Future Directions of High Availability.

    Microsoft Stepping Up to the Plate.

    What's Coming in Yukon for High Availability?

      Enhancements in Fail-over Clustering (SQL Clustering).

      Database Mirroring for Fail-over.

      Combining Fail-over and Scale Out Options.

    Data Access Enhancements for Higher Availability.

    High Availability from the Windows Server Family Side.

      Microsoft Virtual Server 2005.

      Virtual Server 2005 and Disaster Recovery.

    Other Industry Trends in High Availability.




Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership