join the MSSQLTips community

MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

 
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2 - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

Last post 07-15-2009 1:29 AM by GDST_Admin. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 03-02-2009 12:30 AM

    Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

    This post is related to this tip: Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

    http://www.mssqltips.com/tip.asp?tip=1698

  • 07-14-2009 7:51 AM In reply to

    Re: Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

    If I was to create a Node and Disk Majority for an Active Passive Cluster on SQL 2008 (Just 2 nodes)

    Is it true that, if the disk quorum failed.  SQL Server 2008 will continue running, but no failover ability until disk quorum is fixed.  Or will SQL Server 2008 stop running altogether until quorum is fixed?

      

     

  • 07-14-2009 2:14 PM In reply to

    Re: Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

    In this quorum model, a cluster remains active until half of the nodes and its witness disk is available. In case the witness/quorum disk failed, the cluster requires a majority of nodes to be up and running in order to successfully run the cluster or in this case, the SQL Server service. Simply put, for a 2-node cluster, both nodes have to be up and running when the witness/cluster disk fails to make sure that the SQL Server service continues to run. Here's a challenge, run this test on a virtual environment having the cluster disks on a shared storage, probably an iSCSI disk. To simulate a failed qitness/quorum disk, disable the network card that connects to your shared storage. While you're at it, connect to SQL Server and see if you can connect properly. That will provethe point. 

  • 07-15-2009 1:29 AM In reply to

    Re: Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2

    Thanks for your info. 

    I just want to clear up whether this is the case with Active / Passive Node Or does it have to be Active / Active Node.

    I am going to be running just Active Passive.  From what you are saying.  If the disk quorum failed as long as both the Active and Passive nodes are still running.  Cluster will run but no failover ability.  Therefore, time to fix the quorum disk.  Once thats fixed, failover ability will return.

Page 1 of 1 (4 items)