I agree and then setup Mirroring or Transaction Log shipping for DR/High Availaibility of the databases to another SQL instance at another site. I don't see too many NLB SQL setups these days, but Clustered 2-4-8 node SQL Environments and even Stretch (Globally/Geo Dispersed) Clusters are gaining traction...
Z From: Mayo, Bill [mailto:[email protected]] Sent: Thursday, February 18, 2010 5:02 PM To: NT System Admin Issues Subject: RE: SQL Cluster Sensitivity: Confidential What are you trying to accomplish? I imagine that you could technically setup a NLB cluster for SQL, but it would logically mean that the data is read only and is synchronized in some other fashion. If you are looking for a multi-server SQL solution where the data is shared, then you are doing a MSCS cluster. In that type of situation, any given database can only be accessed by one SQL Server at a time. Windows does not permit having 2 servers access the same disk resource simultaneously. A NLB cluster means that you are spreading requests to multiple servers, all of which are active. This is commonly used for clustering web servers. A MSCS cluster means that you are utilizing shared storage and have 2 or more servers with resource groups spread between them. Only one server can access any particular resource group at a time. This is commonly used for SQL Server, and is the Exchange 2003 and earlier method for clustering as well. Bill Mayo ________________________________ From: Cameron Cooper [mailto:[email protected]] Sent: Thursday, February 18, 2010 4:56 PM To: NT System Admin Issues Subject: RE: SQL Cluster Sensitivity: Confidential Is there documentation out there that shows how this is setup? _____________________________ Cameron Cooper System Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com From: Sean Rector [mailto:[email protected]] Sent: Thursday, February 18, 2010 3:51 PM To: NT System Admin Issues Subject: RE: SQL Cluster Sensitivity: Confidential Yep...the Data & Log drives are on my iSCSI SAN. Sean Rector, MCSE From: Cameron Cooper [mailto:[email protected]] Sent: Thursday, February 18, 2010 4:38 PM To: NT System Admin Issues Subject: SQL Cluster Sensitivity: Confidential Can you setup two SQL servers to Load-Balanced Cluster? Or is this not suggested for SQL? _____________________________ Cameron Cooper System Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com Information Technology Manager Virginia Opera Association E-Mail: [email protected] <mailto:[email protected]> Phone: (757) 213-4548 (direct line) {+} Virginia Opera's 35th Anniversary Season <http://www.vaopera.org> The One You Love Celebrate with a 2009-2010 subscription: La Bohème <http://www.vaopera.org/html/currentoperas/opera1.cfm> | The Daughter of the Regiment <http://www.vaopera.org/html/currentoperas/opera2.cfm> | Don Giovanni <http://www.vaopera.org/html/currentoperas/opera3.cfm> | Porgy and BessSM <http://www.vaopera.org/html/currentoperas/opera4.cfm> Visit us online at www.VaOpera.org <http://www.vaopera.org/> or call 1-866-OPERA-VA The vision of Virginia Opera is to enrich lives through the powerful integration of music, voice and human drama. ________________________________ This e-mail and any attached files are confidential and intended solely for the intended recipient(s). Unless otherwise specified, persons unnamed as recipients may not read, distribute, copy or alter this e-mail. Any views or opinions expressed in this e-mail belong to the author and may not necessarily represent those of Virginia Opera. Although precautions have been taken to ensure no viruses are present, Virginia Opera cannot accept responsibility for any loss or damage that may arise from the use of this e-mail or attachments. {*} ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
