Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

by Michael Otey

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Create a Highly Available Microsoft SQL Server 2008 Environment

Written by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing instant data backups. Filled with detailed instructions, Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring takes you from planning to management of a robust high availability solution.

• Configure Windows Failover Clustering
• Set up the Microsoft Distributed Transaction Coordinator on a two node failover cluster
• Install SQL Server 2008 on your cluster
• Handle cluster management and backup
• Configure and manage database mirroring for high availability
• Implement Hyper-V virtualization and Live Migration
• Manage a SQL Server virtual machine

Michael Otey is the technical director for SQL Server Magazine and Windows IT Pro and the bestselling author of Microsoft SQL Server 2005 Developer's Guide, Microsoft SQL Server 2008 New Features, and several other books. He is president of TECA, Inc., a software development and consulting company.

Product Details

ISBN-13:	9780071498135
Publisher:	McGraw Hill LLC
Publication date:	12/17/2009
Pages:	304
Product dimensions:	7.30(w) x 9.00(h) x 0.60(d)

About the Author

Michael Otey is the technical director for Windows IT Pro and SQL Server Magazine, and a bestselling SQL Server author.He is president of TECA, Inc., a software development and consulting company. He is the author of Microsoft SQL Server 2005 Developer’s Guide, Microsoft SQL Server 2008 New Features, and several other books on SQL Server.

Table of Contents

Chapter 1. Planning for High Availability; Part I: Implementing Windows Failover Clustering; Chapter 2. Windows Failover Clustering Architecture; Chapter 3. Configuring Failover Clustering; Chapter 4. Configuring SQL Server Failover Clustering; Chapter 5. Managing Failover Clustering; Part II: Implementing Database Mirroring; Chapter 6. Database Mirroring Architecture; Chapter 7. Configuring Database Mirroring; Chapter 8. Managing Database Mirroring; Part III: Implementing Hyper-V Virtualization and Live Migration; Chapter 9. Virtualization and Live Migration Architecture; Chapter 10. Configuring Hyper-V Live Migration; Chapter 11. Configuring SQL Server with Hyper-V Live Migration; Chapter 12. Managing the Virtual SQL Server; Index