Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Multiple SQL 2008 Instances

Posted on 2009-07-16
2
Medium Priority
?
355 Views
Last Modified: 2012-05-07
I currently have a 2 node A/P SQL 2008 Cluster running once instance on Server 2008 Ent. I have 3 disks that have been allocated for the instance (Data, Logs, Backups) I would like to add an additional instance to the cluster and utilize the same disks. Is this possible. I have tested this and noticed that once you have disks allocated in the Failover Cluster Manager. There is no way to allocate those same disks to a different resource? Any Help would be greatly appreciated.

LANadmn
0
Comment
Question by:LANadmn
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 24870223
with clustering, each instance must have it's own resources.
so, you cannot share multiple instances with the same resources.

instead, you must  either put the database(s) into the same instance, or instead get more disk to be cluster resourced.
0
 

Author Comment

by:LANadmn
ID: 24870268
I though that was the case. I guess that why HP has the PolyServe product
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

885 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