Solved

Multiple SQL 2008 Instances

Posted on 2009-07-16
2
336 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 250 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

734 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