Pro SQL Server 2005 High Availability

This book comprehensively covers the technology, the people, the process, and the real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances. This book is based on real-world experience.

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 realworld 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 indepth, 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 realworld 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 enterpriseclass, 24x7 SQL Server 2005 implementations.
• You'll gain insight that other SQL Server documentation and whitepapers don't provide.

Provides comprehensive, clear, detailed coverage of all major availability issues Covers both availability and performance, from the perspective of high availability Addresses the crucial needs of enterprise-class, 24x7 SQL Server 2005 implementations Tells you what SQL Server documentation and whitepapers don't

Auteur
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.

Contenu

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.