Installing SQL Server 2008 failover cluster in Windows 2008 R2 cluster

Prerequisites

  1. SQL Server 2008 Standard/Enterprise/Developer edition install Media with Service pack 2.
  2. One IP address as SQL Cluster virtual IP and host-name as SQL Cluster virtual host-name. Our clients will have to use this host-name or IP to connect with this fail-over instance.
  3. One shared disk to place all our System DB files + error-logs etc
  4. Minimum two identical clustered Windows 2008 Servers.
  5. … Will be adding more. Couldn’t remember all of them at one shot. Please add any missed out points below as comments. Thanks in advance.

Method

  1. Log-in to any one node and move all the cluster resources to that node.
  2. Navigate to the media directory and execute the below command. This is to make sure we don’t move all the SQL server binary files into C drive.
    setup.exe /ACTION=INSTALLFAILOVERCLUSTER /INSTALLSHAREDDIR=”J:\Program Files\Microsoft SQL Server” /INSTALLSHAREDWOWDIR=”J:\Program Files (x86)\Microsoft SQL Server”.
  3. Follow the instructions on the setup wizard.

To be continue…

Author: Sherbaz

Being a gadget enthusiast, He always felt good to try new programming languages and techniques. But never goes in-depth anywhere. www.SplitExpense.in was found when he tried php, html, javascript and mysql. Being an electronics engineer, he is also interested to build small gadgets and tools in embedded and digital electronics. As a profession, he handles microsoft sql server database and calls himself a database administrator

Leave a Reply