Solved

Adding a new instance on a Active\Passive SQL2008 Cluster

Posted on 2011-03-11
5
239 Views
Last Modified: 2012-05-11
As the titile says we currently have a Windows Server 2008 failover cluster with SQL Server 2008 default instance.  We need to install a new named instance on the same failover cluster.  Doing some preliminary  research I found that the new instance needs to have its own set of disks.  Is this true?  Does anyone know of any good resources to read up on this?  Any help would be greatly appriciated.
0
Comment
Question by:cgitst
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 3

Expert Comment

by:tearman
ID: 35112847
I don't think you should need a different set of disks for a separate instance (albeit they probably recommend it for performance reasons).

I think you'll have to go into the SQL installer and set up a named instance separate to the active/passive failover cluster.  Might check with your Microsoft provider on licensing though...
0
 

Author Comment

by:cgitst
ID: 35112928
When running ht eSQL setup during the validation checks it returns an error saying there are no available disks for the SQL cluster.  even though I obviously know I have disks which ar ein use by the deault instance.
0
 
LVL 8

Accepted Solution

by:
dba2dba earned 250 total points
ID: 35112965
You need to have separate storage for installing second instance. The whole point in clustering is to give hardware redudnacy to SQL Server.

If you wish to install 2nd instance on same storage, you will not be able to run those on different nodes.
(I dont exactly remeber if you could use same storage for both instances)

This links has more details:

http://sqldbpool.com/2009/10/07/sql-server-2008-active-passive-cluster-installation/

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/05cf41b7-c558-44bf-86c6-12f5c2b2ffe2


Thanks,
0
 
LVL 70

Expert Comment

by:Qlemo
ID: 35763245
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question