Pro SQL Server 2005 High Availability

1. Auflage 2007
ISBN: 978-1-59059-780-4
Verlag: Apress

Buch, Englisch, 745 Seiten, Format (B × H): 185 mm x 245 mm, Gewicht: 1397 g

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.

Zielgruppe

Popular/general

Autoren/Hrsg.

Hirt, Allan

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

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.

Über Autor(innen)

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.