Pro SQL Server 2005 High Availability

by Allan Hirt

Overview

Maintaining SQL Server 2005 high availability in a global information environment is the database administrators greatest practical challenge. Availability is as much about people and processes as it is about technology. Pro SQL Server 2005 High Availability covers the technology, people, processes, and real–world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.

With years of experience as a database consultant and production database administrator, Allan Hirt provides in–depth, detailed advice on what it takes to ensure SQL Server high availability for businesses of any size. This is not an academic text; it's not based on lab experiments, but on real–world experience. This book is a dramatic update and revision of the authors previous best-seller on SQL Server 2000. It gives sound guidance to database and system administrators on how to really get the job done.

• This book provides comprehensive, clear, detailed coverage of all major availability issues.
• The author covers both availability and performance, from the perspective of high availability.
• The book addresses the crucial needs of enterprise–class, 24x7 SQL Server 2005 implementations.
• You'll gain insight that other SQL Server documentation and whitepapers don't provide.

Product Details

ISBN-13:	9781590597804
Publisher:	Apress
Publication date:	07/24/2007
Series:	Expert's Voice in SQL Server Series
Edition description:	First Edition
Pages:	745
Product dimensions:	7.01(w) x 9.25(h) x 0.28(d)

About the Author

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://www.sqlha.com and at @SQLHA on Twitter.

Table of Contents

Part 1 Ups and Downs: A High Availability Primer: The Business of Availability.- Do Not Pass Go Without $200.- Part 2 SQL Server Availability Technology: Failover Clustering Part 1: Windows.- Failover Clustering Part 2: SQL Server.- Backup.- Log Shipping.- Database Mirroring.- Replication.- Making Your Data Available.- So What Do I Use?.- Designing Solutions for Availablility and Performance.- Part 3 - Administration for High Availability: 24x7 Database Administration and Maintenance.- Monitoring.- Recovering From Failure.- Appendix A Glossary.