Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Multiple SQL 2008 Instances

Posted on 2009-07-16
2
Medium Priority
?
348 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
[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
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

715 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