買這商品的人也買了...
-
$399Solaris Internals: Core Kernel Architecture -
Writing Secure Code, 2/e (Paperback)$2,010$1,910 -
Tomcat 技術手冊 (Tomcat: The Definitive Guide)$720$569 -
建構嵌入式 Linux 系統$780$616 -
Windows 程式設計使用 MFC (Programming Windows with MFC, 2/e)$990$782 -
Performance Tuning for Linux Servers(Hardcover)$2,170$2,062 -
SQL 語法範例辭典$550$468 -
Visual Basic 2005 程式設計與案例剖析$650$553 -
Java 程式設計藝術 (Java How to Program, 6/e)$850$765 -
$1,225MCTS Self-Paced Training Kit (Exam 70-529): Microsoft .NET Framework 2.0 Distributed Application Development -
Pro SQL Server 2005 Replication$2,220$2,109 -
寫給 SA 的 UML/MDA 實務手冊$350$315 -
深入淺出物件導向分析與設計 (Head First Object-Oriented Analysis and Design)$880$616 -
After Effects CS3 映畫魔法─影視特效設計實例解析$680$612 -
Adobe Flash CS3 Professional On Demand (Paperback)$1,670$1,587 -
$1,615High Performance Switches and Routers (Hardcover) -
現代嵌入式系統開發專案實務－菜鳥成長日誌與專案經理的私房菜$600$480 -
Embedded Linux 開發實務徹底研究 (Embedded Linux Primer: A Practical Real-World Approach)$720$612 -
深入淺出 PMP (Head First PMP)$880$695 -
軟體建構之道 (Code Complete, 2/e)$1,200$1,020 -
Linux 速學捷徑─Ubuntu 7.10 高手制霸技$269$242 -
Learning Python, 3/e$1,550$1,473 -
Windows Workflow Foundation 新一代工作流程開發實務$550$468 -
WiMAX 技術原理與應用 (Fundamentals of WiMAX)$580$458 -
Mac 玩家秘技－阿西摩的蘋果學習誌$480$432
相關主題
商品描述
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
