Improve company productivity with a Business Account.Sign Up

x
?
Solved

Multiple SQL 2008 Instances

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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A procedure for exporting installed hotfix details of remote computers using powershell
In this article, we will discuss how you can secure Active Directory using free tools, and how you can choose a safe and secure Active Directory security auditing tool.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
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:…

607 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