Pro SQL Server 2005 High Availability

Allan Hirt

  • 出版商: Apress
  • 出版日期: 2007-07-24
  • 售價: $2,110
  • 貴賓價: 9.5$2,005
  • 語言: 英文
  • 頁數: 745
  • 裝訂: Hardcover
  • ISBN: 159059780X
  • ISBN-13: 9781590597804
  • 相關分類: MSSQLSQL
  • 已過版

買這商品的人也買了...

商品描述

Description

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 DBA, 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; its 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 DBAs 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.
  • Youll gain insight that other SQL Server documentation and whitepapers dont provide.

 

 

Table of Contents

Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix
About the Author. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii
Acknowledgments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii
PART 1 n n n The Building Blocks of High Availability
nCHAPTER 1 The Business of Availability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
nCHAPTER 2 Pay Now or Pay Later . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
PART 2 n n n Always On: SQL Server Technology
nCHAPTER 3 Backup and Restore. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
nCHAPTER 4 Failover Clustering: Preparing to Cluster Windows . . . . . . . . . . . . . . . . . . 107
nCHAPTER 5 Failover Clustering: Clustering Windows. . . . . . . . . . . . . . . . . . . . . . . . . . . . 131
nCHAPTER 6 Failover Clustering: Windows Server Cluster Administration . . . . . . . . . 205
nCHAPTER 7 Failover Clustering: Preparing to Cluster SQL Server 2005 . . . . . . . . . . . 225
nCHAPTER 8 Failover Clustering: Clustering SQL Server 2005 . . . . . . . . . . . . . . . . . . . . 249
nCHAPTER 9 Failover Clustering: SQL Server 2005 Failover Clustering Administration. . . 321
nCHAPTER 10 Log Shipping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 363
nCHAPTER 11 Database Mirroring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 425
nCHAPTER 12 Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 479
nCHAPTER 13 Making Your Data Available. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 529
PART 3 n n n Administration for High Availability
nCHAPTER 14 Designing High Availability Solutions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 553
nCHAPTER 15 24x7 Database Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 579
nCHAPTER 16 24x7 Database Maintenance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 673
nCHAPTER 17 Disaster Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 713
nINDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 725