Microsoft SQL Server High Availability

Microsoft SQL Server High Availability (Windows Server System)
By: Paul Bertucci
ISBN: 0672326256

ISBN-13: 9780672326257
Publisher: Sams - 2004-11-05
Paperback | 456 Pages


From the Publisher

Microsoft SQL Server High Availability: A Complete Guide is the first book that explains how to assess, select, and build high availability solutions from the ground up. Chief architects, system and data architects, system and database administrators, and developers will all benefit from this guide. Learn valuable skills, including how to drill-down into the heart of high availability requirements, how to assess and classify these requirements, and how to select, configure, and specify a matching high availability solution that optimally meets your needs. Most importantly, learn how to achieve five 9s (99.999% uptime).


Synopsis Intended for system architects and database administrators, this guide describes the various hardware and software options within the Microsoft family of products that address high availability, and defines a formal design approach for matching a company's computer system requirements to the appropriate availability solution. Four example business cases walk through the implementation of Cluster Services, SQL clustering, log shipping, data replication, and distributed transaction processing.
Annotation ©2004 Book News, Inc., Portland, OR
Table of Contents Pt. I Understanding high availability Ch. 1 Essential elements of high availability 5 Pt. II Choosing the right high availability approaches Ch. 2 Microsoft high availability options 31 Ch. 3 Choosing high availability 53 Pt. III Implementing high availability Ch. 4 Microsoft cluster services 91 Ch. 5 Microsoft SQL server clustering 127 Ch. 6 Microsoft SQL server log shipping 167 Ch. 7 Microsoft SQL server data replication 195 Ch. 8 Other ways to distribute data for high availability 271 Ch. 9 High availability pieced together 295 Ch. 10 High availability design issues and considerations 315 Ch. 11 High availability and security 369 Ch. 12 Future directions of high availability 391