Solved

Adding a new instance on a Active\Passive SQL2008 Cluster

Posted on 2011-03-11
5
234 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
5 Comments
 
LVL 3

Expert Comment

by:tearman
Comment Utility
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
Comment Utility
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
Comment Utility
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 68

Expert Comment

by:Qlemo
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now