This book helps you implement robust database clustering and mirroring solutions. Featuring practical management procedures and realistic case studies, this new volume details the latest database and server failure prevention techniques for SQL Server 2005. You will learn practical steps to ensure zero database loss, avoid system downtime, and provide instant data backups.

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

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.