Actually its recommended that you do Active Passive with the SQL clusters, now if you have multiple instances, then you can create additional SQL groups and balance them on each node if you want (See the following site : http://www.mssqltips.com/tip.asp?tip=1554)
And this is the clustering best practices Whitepaper for SQL 2005... http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4 f09-b282-c6830fead499&displaylang=en Z Edward Ziots CISSP,MCSA,MCP+I,Security +,Network +,CCA Network Engineer Lifespan Organization 401-639-3505 [email protected] From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:27 PM To: NT System Admin Issues Subject: RE: Network Share unshares This should probably be another topic (hacking my own)... Currently we have the two clustered with one as the active node and the other as the inactive, is there a way that we can setup the two to load balance the database? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, July 07, 2010 12:17 PM To: NT System Admin Issues Subject: RE: Network Share unshares You're welcome. It should bounce over to the inactive node just like SQL and any other configured resources. From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:15 PM To: NT System Admin Issues Subject: RE: Network Share unshares Thank you sir. Setup the resource and will see what happens when the server is restarted tonight. _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, July 07, 2010 11:55 AM To: NT System Admin Issues Subject: Re: Network Share unshares You have to make the share a clustered resource. Just create it in the cluster admin tool. On Wed, Jul 7, 2010 at 12:54 PM, Cameron Cooper <[email protected]> wrote: We have two SQL Servers clustered into a Dell MD3000 and have a folder that is shared. When either of the clustered servers restarts the share is gone. Any ideas on how to resolve this? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected] | www.aurico.com ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
