SQL 2008 R2 Cluster + Multiple Instances

Question

Hi,

I have recently built a 2 node SQL 2008 R2 cluster which is running well with a named instance.  I had intended on having 3 instances running on this however when I try to install the second instance I get an error stating that there is no shared drive available.

On further reading it appears I may need to add a new disk resource to support the second instance?  I just want to confirm if this is the case as I can't actually find any decent documentation to prove or disprove this.

Thanks

Leon

Answer 1

Please check-out

http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

Hello,

You can confirm that in the following article:

“A combination of one or more disks in a Microsoft Cluster Service (MSCS) cluster group, also known as a resource group. Each resource group can contain at most one instance of SQL Server.”

http://msdn.microsoft.com/en-us/library/ms179410(v=SQL.100).aspx  

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 3

Thank you very much!