SQL Server Technical Article
Writers: Mike Weiner, Paul Burpo, Max Verun, Joseph Sack, Justin Erickson
Contributors: Sanjay Mishra, Jason Wu, Uttam Parui
Technical Reviewers: Prem Mehra, James Podgorski, David Whitney, Richard Tkachuk, Sethu Kalavakur, Cindy Gross, Neal Graves, Farzan Ratistari, Ayad Shammout (Caregroup Healthcare Systems), David P. Smith(ServiceU Corporation)
Published: June 2009
Applies to: SQL Server 2008
Summary: This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for atechnical audience. This white paper covers failover cluster architecture and concepts for Windows Server and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.
The information contained in this document represents the current view of Microsoft Corporation onthe issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
This white paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED, ORSTATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose,without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights,or other intellectual property.
Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.
© 2009 Microsoft Corporation. Allrights reserved.
Microsoft, Active Directory, Excel, Hyper-V, SQL Server, Win32, Windows, Windows Server, and Windows Vista are trademarks of the Microsoft group of companies.
All other trademarks are property of their respective owners.
Overview of Windows Server Failover Clustering 5
Topology and Architecture of a SQL Server Cluster 8
Failover Cluster ResourceGroup 9
Health Detection 10
Resource and Resource Group Properties 11
Resource Properties 11
Resource Group Properties 13
Common SQL Server Failover Deployments 14
Single Failover Cluster Instance 14
Multi-Instance Failover Cluster 15
Multi-Site Failover Cluster 15
Guest Failover Cluster 17
Multiple SQL Server Versions Within the Same Windows Server Cluster (SQL Server 2000 and2005 with SQL Server 2008) 18
Advantages of SQL Server 2008 on Windows Server 2008 Clustering 19
SQL Server Installation and Setup 20
Installation Options for a SQL Server Failover Cluster 21
Integrated Installation 21
Advanced/Enterprise Installation 21
Adding a Node to a Failover Instance 22
Removing a Node from a Failover Instance 22
Uninstalling a SQL Server Instance 23