# 安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 1 篇 SQL Server 2008 容錯轉移叢集架設沒想像這麼簡單，絕對不是照著安裝精靈按下一步、下一步就能夠完成的，而且 SQL Server 2008 RTM 版本根本無法成功架設叢集，害我第一次架設了 6 小時然後在最後一步失敗，最後安裝失敗的 SQL 資料庫實體還移不掉，只好從作業系統全部重新再來一次，這難得的經驗還是要記錄一下，但由於步驟太多，所以會區分幾篇文章。 **準備叢集電腦兩台 （可用 Hyper-V 架設）** - 作業系統必須安裝 Windows Server 2008 企業版 ( 我是安裝 Windows Server 2008 **R2** Enterprise ) - 安裝/設定兩張網路卡 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/f1f7c0d2f890eff407a8-image.png) - Node 1 (第一台電腦) - NIC1 IP: 192.168.5.91 - NIC2 IP: 10.0.0.1 - Node 2 (第二台電腦) - NIC1 IP: 192.168.5.92 - NIC2 IP: 10.0.0.2 - 設定電腦名稱並加入網域 - SQL-1 - SQL-2 **準備共享磁碟 ( 請參考 [WSS2008 的 iSCSI Software Target 3.2 設定筆記](/post/2010/01/11/Windows-Storage-Server-2008-iSCSI-Software-Target-32-Setup) 進行安裝設定 )** - 我們透過 iSCSI Target 提供 4 個共享磁碟區 - **叢集仲裁磁碟** (Quorum Disk)，大約給 1GB 即可 - **分散式交易調節器(MSDTC) 專用磁碟**，大約給 1GB 即可 - **SQL Server 系統資料庫專用磁碟**，大約給 20GB 即可 ( 測試用途 ) - **SQL Server 使用者資料庫專用磁碟**，大約給 20GB 即可( 測試用途 ) - **建議軟體** - [iSCSI SAN Software and Storage Virtualization Solutions - StarWind Software](http://www.starwindsoftware.com/) (有免費版) - **Windows Storage Server 2008 with iSCSI Software Target 3.2** 建立 iSCSI Target 的時候必須同時指定給兩台主機使用（如下圖示）（點圖可放大） [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0a48df5c55700213f089-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/fc4487efd6ff25cfa6db-image.png) **將兩台叢集電腦都掛載四個 iSCSI Target 共享磁碟區** - **仲裁磁碟** (Quorum Disk) 指派 **Q:** 磁碟代號  ( 通常仲裁磁碟都習慣用 Q: 做為磁碟代號 ) - **MSDTC (分散式交易) 專用磁碟** 指派 **D:** 磁碟代號 - **SQL Server 系統資料庫專用磁碟** 指派 **E:** 磁碟代號 - **SQL Server 使用者資料庫專用磁碟** 指派 **F:** 磁碟代號 到目前為止兩台叢集電腦的設定都是一模一樣的，設定完成後的磁碟配置圖示如下： ![image](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c82959dde1897af8a944-image.png "image") **新增「應用程式伺服器」角色** [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/7ff89fdd031409f43c80-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/b7fcb8b1e50dc888d957-image.png) 在安裝「應用程式伺服器」的「選取角色服務」時必須選取「連入遠端交易」與「連出遠端交易」  ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/89d3603299b33416a759-image.png) **新增「容錯轉移叢集」功能** ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/847e4fedb74011d400a6-image.png) ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5d6635107f935e16ec31-image.png) **進入「容錯移轉叢集」功能，並驗證所有設定** ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/536212931223241f8c0b-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/37416261a4e0b1ffb595-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/4d95009816b5378ef65f-image.png) 將所有需要加入叢集的主機新增進來驗證 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/ff3e0ccdc6686232b949-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/706170de1cb4325b20cc-image.png) 建議**執行所有測試** ( 注意：你不需要兩台同時執行測試，只要在其中壹台執行測試即可 ) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/eb0df735b5921244d1b3-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/03c483096711b01b5711-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/5448556169a24caee80b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c6d98eb422f4b939e72a-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2ad9be05173229f7c9c4-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/2c8d54d152126b1e2a0c-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c3d8d0e420ad56a5ef95-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/a4df53213e159203c908-image.png) 如果都沒有問題，就可以準備開始**建立叢集**了。我們直接在**第一台**建立叢集即可： ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/4b5ba8cec9db6c1321a7-image.png)  [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/a21becd51ba33f42216f-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/14c1a8828597434a8792-image.png) 設定「叢集電腦名稱」與「管理叢集用的 IP 位址」 [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e17f4a48d92d94e8a160-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/581f96bd9b4438cbfd25-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/d40e440ca744ffc03398-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0d9d49a76e90f43d9b1a-image.png) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/62c57865681d661a522d-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c8cb4a04a016afbc5311-image.png) 我們在**第一台**建立完成之後，可以直接到**第二台**主機查看會發現叢集也一併設定完成，而且我們之前準備的 4 個共享磁碟也會全部被掛載成「叢集磁碟」，其中 **Q:** 會自動被使用成 **仲裁磁碟** (Quorum Disk) [![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/c3de46b1d53f7002761b-image_thumb.png)](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/0e89b8acae0901eff429-image.png) 而且 2 個叢集網路中也會自動將 10.0.0.xx 開頭的網路變成「內部」專用的專屬介面，用來偵測**心跳**之用 ![](https://stwillblogassets.blob.core.windows.net/files/images/external/stwillblogassets.blob.core.windows.net/e89b088083ef8a4854db-image.png)  咱們今天就先到這，這回先把**小菜**給吃了，下回開始吃點重口味的：**安裝 SQL Server 容錯移轉叢集!** **相關連結** - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1](http://www.mssqltips.com/tip.asp?tip=1687) - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2](http://www.mssqltips.com/tip.asp?tip=1698) - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 3](http://www.mssqltips.com/tip.asp?tip=1709) - [Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4](http://www.mssqltips.com/tip.asp?tip=1721) - [Understanding why there is still downtime with Microsoft Clustering](http://www.mssqltips.com/tip.asp?tip=1882) - [SQL Server 2008 容錯移轉叢集使用者入門](http://msdn.microsoft.com/zh-tw/library/ms189134.aspx) **之前遇到安裝失敗的問題與解答相關連結** - [How to resolve RequireKerberos value problem in sql 2008 failover cluster...](http://www.sqlservercentral.com/Forums/Topic723728-391-1.aspx) - [Failover Cluster installation fails (SQLServer 2008)](http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/6ccf9380-852d-4b59-b128-97e0e870452c) - [How to update or slipstream an installation of SQL Server 2008](http://support.microsoft.com/kb/955392/en-us) - [SQL Server 2008 Slipstream Frequently Asked Questions](http://blogs.msdn.com/petersad/archive/2009/04/24/sql-server-2008-slipstream-frequently-asked-questions.aspx) - [SQL Server 2008, basic slipstream steps](http://blogs.msdn.com/petersad/archive/2009/03/02/sql-server-2008-basic-slipstream-steps.aspx) - [Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1](http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx) - [SQL Server 2008 failover cluster rolling patch and service pack process](http://support.microsoft.com/kb/958734/en-us) **完整安裝 SQL Server 2008 容錯轉移叢集的步驟文章** - [安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 1 篇](/post/2010/01/17/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-1) - [安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 2 篇](/post/2010/01/18/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-2) - [安裝 SQL Server 2008 容錯轉移叢集心得筆記 – 第 3 篇 (完)](/post/2010/01/19/SQL-Server-2008-Failover-Cluster-Installation-Notes-Part-3)