Microsoft® SQL Server™ 2000 High Availability

Microsoft® SQL Server™ 2000 High Availability
Published:July 09, 2003Language:English
Author:Allan Hirt with Cathan Cook, Kimberly L. Tripp, Frank McBathTechnology:Microsoft SQL Server 2000
Length:784 PagesISBN 13:9780735619203

List Price:

$ 49.99
About The BookLearn how the experts help maximize the uptime—and performance—of SQL Server 2000-based systems.

Get the definitive reference to maximizing the availability of your critical, SQL Server 2000-based business systems. Developed by Microsoft field consultants who create and support high availability solutions every day, this practical guide explains how to plan, design, implement, and support highly available SQL Server 2000-based systems for both 32-bit and 64-bit environments. You get in-depth, end-to-end guidance—from evaluating availability requirements and capacity planning to implementing failover clustering, log shipping, replication, system backup and restore, system recovery, and other technologies and processes. Real-world scenarios illustrate the book’s best practices in action. You also get a CD featuring evaluation software, planning worksheets, scripts, and other on-the-job resources.Discover how to:
  • Evaluate technical, staffing, and budget requirements
  • Plan and configure disk subsystems for performance and availability
  • Configure Microsoft Windows® 2000 Server or Microsoft Windows Server™ 2003 to optimize SQL Server 2000 availability
  • Plan, implement, and maintain a base server cluster and Network Load Balancing
  • Plan and configure failover clustering
  • Use built-in log shipping features or code your own
  • Create comprehensive backup and restore plans
  • Choose replication methods for high availability—and expose replication architecture
  • Develop prevention and disaster recovery strategies; sample runbook and scripts included on CD
  • Minimize downtime for server upgrades and service pack installations
  • Baseline performance and use availability-monitoring tools and techniquesCDs feature:
  • 120-day evaluation version of SQL Server 2000 Enterprise Edition
  • Scripts for custom log shipping, backup and restoration, system monitoring, and other administrative tasks
  • Sample disaster-recovery runbook
  • Worksheets, checklists, and templates
  • Fully searchable eBook
  • About Allan Hirt with Cathan Cook, Kimberly L. Tripp, Frank McBathFounded in 1975, Microsoft (NASDAQ 'MSFT') is the worldwide leader in software for personal and business computing. The company offers a wide range of products and services designed to empower people through great software—any time, any place, and on any device.
    Allan Hirt, Consultant, Microsoft Consulting Services (MCS), is the main writer. Contributors include Kimberly Tripp, SQL Server Trainer, Cathan Cook, Consultant, MCS, and Frank McBath, Technologist, Microsoft, who will write selected chapters.

    Allan has been involved extensively in work with SQL Server and high availability over the past two years. His credentials include:
  • The 'SQL Server 2000 Failover Clustering" white paper posted to
  • Authoring part of the courseware for the SQL Server High Availability Event in Redmond, WA (June 2001)
  • Leading SQL Server 2000 High Availability Post-Training at MGB, 2001
  • Authoring the customer-ready version of the High Availability Event material (both the one-day and the three-day)
  • Wrote chapters (including “Log Shipping,” “Failover Clustering,” “Five Nines,” and “Federated Servers”) for the SQL Server 2000 Resource Kit
  • Speaking on high availability at conferences such as TechEd, MGB, and SQL PASS
  • Subject Matter Expert for the internal eKM Database community, 2001
  • Other Books By Microsoft Corporation
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book? Your feedback is important in helping us create books that serve your needs and meet your expectations.Please take our survey at

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey.The ISBN 13 can be found above.
    To report or search for corrections in this book or its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.