Microsoft® SQL ServerTM 2000 High Availability

Front Cover
Microsoft Press, Nov 30, 2009 - Computers - 784 pages

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 techniques

CDs 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

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to

What people are saying - Write a review

We haven't found any reviews in the usual places.

Other editions - View all

About the author (2009)

Allan Hirt is a Microsoft Cluster"Most Valuable Professional"living just outside of Boston. Starting as an intern at Sybase in college, Allan has used SQL Server in its various forms since 1992. For the past 10 years, he has traveled all over the world to train, mentor, and work with clients. He has also authored or contributed to publications about SQL Server for various outlets including Microsoft and SQL Server Magazine via whitepapers, webcasts, training courses, and books. He is a frequent speaker at conferences like TechEd and SQL PASS. Allan's website and blog can be found at http: // and at @SQLHA on Twitter.

Cathan Cook, Consultant, MCS, lives in Redmond, WA/Waltham, MA

Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. She lectures for a variety of events including Microsoft Tech*Ed and is married to co-editor and SQL guru Paul Randal.

McBath is an SQL Server specialist in Microsoft's Enterprise Applications Practice.

Bibliographic information