Solved

Multiple SQL 2008 Instances

Posted on 2009-07-16
2
304 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 142

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
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:…

895 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

15 Experts available now in Live!

Get 1:1 Help Now